﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SaludOcupacionalDataSet" targetNamespace="http://tempuri.org/SaludOcupacionalDataSet.xsd" xmlns:mstns="http://tempuri.org/SaludOcupacionalDataSet.xsd" xmlns="http://tempuri.org/SaludOcupacionalDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SaludOcupacionalConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SaludOcupacionalConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SaludOcupacional.Properties.Settings.GlobalReference.Default.SaludOcupacionalConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnalisisAudiometricoTableAdapter" GeneratorDataComponentClassName="AnalisisAudiometricoTableAdapter" Name="AnalisisAudiometrico" UserDataComponentName="AnalisisAudiometricoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.AnalisisAudiometrico" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[AnalisisAudiometrico] WHERE (([cod_analisis] = @Original_cod_analisis) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_oido_izq = 1 AND [oido_izq] IS NULL) OR ([oido_izq] = @Original_oido_izq)) AND ((@IsNull_oido_der = 1 AND [oido_der] IS NULL) OR ([oido_der] = @Original_oido_der)) AND ((@IsNull_bilateral = 1 AND [bilateral] IS NULL) OR ([bilateral] = @Original_bilateral)) AND ((@IsNull_acciones_atomar = 1 AND [acciones_atomar] IS NULL) OR ([acciones_atomar] = @Original_acciones_atomar)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_analisis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_analisis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_oido_izq" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="oido_izq" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_oido_izq" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oido_izq" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_oido_der" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="oido_der" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_oido_der" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oido_der" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bilateral" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bilateral" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_bilateral" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bilateral" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acciones_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[AnalisisAudiometrico] ([ci_empleado], [oido_izq], [oido_der], [bilateral], [acciones_atomar], [observaciones], [fecha]) VALUES (@ci_empleado, @oido_izq, @oido_der, @bilateral, @acciones_atomar, @observaciones, @fecha);
SELECT cod_analisis, ci_empleado, oido_izq, oido_der, bilateral, acciones_atomar, observaciones, fecha FROM AnalisisAudiometrico WHERE (ci_empleado = @ci_empleado) AND (cod_analisis = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@oido_izq" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oido_izq" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@oido_der" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oido_der" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@bilateral" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bilateral" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT cod_analisis, ci_empleado, oido_izq, oido_der, bilateral, acciones_atomar, observaciones, fecha FROM dbo.AnalisisAudiometrico</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[AnalisisAudiometrico] SET [ci_empleado] = @ci_empleado, [oido_izq] = @oido_izq, [oido_der] = @oido_der, [bilateral] = @bilateral, [acciones_atomar] = @acciones_atomar, [observaciones] = @observaciones, [fecha] = @fecha WHERE (([cod_analisis] = @Original_cod_analisis) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_oido_izq = 1 AND [oido_izq] IS NULL) OR ([oido_izq] = @Original_oido_izq)) AND ((@IsNull_oido_der = 1 AND [oido_der] IS NULL) OR ([oido_der] = @Original_oido_der)) AND ((@IsNull_bilateral = 1 AND [bilateral] IS NULL) OR ([bilateral] = @Original_bilateral)) AND ((@IsNull_acciones_atomar = 1 AND [acciones_atomar] IS NULL) OR ([acciones_atomar] = @Original_acciones_atomar)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)));
SELECT cod_analisis, ci_empleado, oido_izq, oido_der, bilateral, acciones_atomar, observaciones, fecha FROM AnalisisAudiometrico WHERE (ci_empleado = @ci_empleado) AND (cod_analisis = @cod_analisis)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@oido_izq" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oido_izq" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@oido_der" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oido_der" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@bilateral" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bilateral" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_analisis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_analisis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_oido_izq" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="oido_izq" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_oido_izq" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oido_izq" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_oido_der" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="oido_der" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_oido_der" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oido_der" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bilateral" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bilateral" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_bilateral" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bilateral" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acciones_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="cod_analisis" ColumnName="cod_analisis" DataSourceName="SaludOcupacional.dbo.AnalisisAudiometrico" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@cod_analisis" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="cod_analisis" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cod_analisis" DataSetColumn="cod_analisis" />
              <Mapping SourceColumn="ci_empleado" DataSetColumn="ci_empleado" />
              <Mapping SourceColumn="oido_izq" DataSetColumn="oido_izq" />
              <Mapping SourceColumn="oido_der" DataSetColumn="oido_der" />
              <Mapping SourceColumn="bilateral" DataSetColumn="bilateral" />
              <Mapping SourceColumn="acciones_atomar" DataSetColumn="acciones_atomar" />
              <Mapping SourceColumn="observaciones" DataSetColumn="observaciones" />
              <Mapping SourceColumn="fecha" DataSetColumn="fecha" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnalisisOftalmologicoTableAdapter" GeneratorDataComponentClassName="AnalisisOftalmologicoTableAdapter" Name="AnalisisOftalmologico" UserDataComponentName="AnalisisOftalmologicoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.AnalisisOftalmologico" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[AnalisisOftalmologico] WHERE (([cod_analisis] = @Original_cod_analisis) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_uso_lentes = 1 AND [uso_lentes] IS NULL) OR ([uso_lentes] = @Original_uso_lentes)) AND ((@IsNull_oi_sin = 1 AND [oi_sin] IS NULL) OR ([oi_sin] = @Original_oi_sin)) AND ((@IsNull_od_sin = 1 AND [od_sin] IS NULL) OR ([od_sin] = @Original_od_sin)) AND ((@IsNull_io_con = 1 AND [io_con] IS NULL) OR ([io_con] = @Original_io_con)) AND ((@IsNull_od_con = 1 AND [od_con] IS NULL) OR ([od_con] = @Original_od_con)) AND ((@IsNull_miopia = 1 AND [miopia] IS NULL) OR ([miopia] = @Original_miopia)) AND ((@IsNull_astigmatismo = 1 AND [astigmatismo] IS NULL) OR ([astigmatismo] = @Original_astigmatismo)) AND ((@IsNull_hipermetropia = 1 AND [hipermetropia] IS NULL) OR ([hipermetropia] = @Original_hipermetropia)) AND ((@IsNull_pterigiun = 1 AND [pterigiun] IS NULL) OR ([pterigiun] = @Original_pterigiun)) AND ((@IsNull_pinguecula = 1 AND [pinguecula] IS NULL) OR ([pinguecula] = @Original_pinguecula)) AND ((@IsNull_seudofaquia = 1 AND [seudofaquia] IS NULL) OR ([seudofaquia] = @Original_seudofaquia)) AND ((@IsNull_daltonismo = 1 AND [daltonismo] IS NULL) OR ([daltonismo] = @Original_daltonismo)) AND ((@IsNull_normal = 1 AND [normal] IS NULL) OR ([normal] = @Original_normal)) AND ((@IsNull_acciones_atomar = 1 AND [acciones_atomar] IS NULL) OR ([acciones_atomar] = @Original_acciones_atomar)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_analisis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_analisis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uso_lentes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uso_lentes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_uso_lentes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="uso_lentes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_oi_sin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="oi_sin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_oi_sin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oi_sin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_od_sin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="od_sin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_od_sin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="od_sin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_io_con" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="io_con" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_io_con" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="io_con" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_od_con" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="od_con" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_od_con" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="od_con" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_miopia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="miopia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_miopia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="miopia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_astigmatismo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="astigmatismo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_astigmatismo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="astigmatismo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hipermetropia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hipermetropia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hipermetropia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hipermetropia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pterigiun" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pterigiun" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_pterigiun" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pterigiun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pinguecula" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pinguecula" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_pinguecula" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pinguecula" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_seudofaquia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="seudofaquia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_seudofaquia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="seudofaquia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daltonismo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daltonismo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_daltonismo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="daltonismo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_normal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="normal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_normal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="normal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acciones_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[AnalisisOftalmologico] ([ci_empleado], [uso_lentes], [oi_sin], [od_sin], [io_con], [od_con], [miopia], [astigmatismo], [hipermetropia], [pterigiun], [pinguecula], [seudofaquia], [daltonismo], [normal], [acciones_atomar], [observaciones], [fecha]) VALUES (@ci_empleado, @uso_lentes, @oi_sin, @od_sin, @io_con, @od_con, @miopia, @astigmatismo, @hipermetropia, @pterigiun, @pinguecula, @seudofaquia, @daltonismo, @normal, @acciones_atomar, @observaciones, @fecha);
SELECT cod_analisis, ci_empleado, uso_lentes, oi_sin, od_sin, io_con, od_con, miopia, astigmatismo, hipermetropia, pterigiun, pinguecula, seudofaquia, daltonismo, normal, acciones_atomar, observaciones, fecha FROM AnalisisOftalmologico WHERE (ci_empleado = @ci_empleado) AND (cod_analisis = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@uso_lentes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="uso_lentes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@oi_sin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oi_sin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@od_sin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="od_sin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@io_con" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="io_con" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@od_con" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="od_con" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@miopia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="miopia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@astigmatismo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="astigmatismo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hipermetropia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hipermetropia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pterigiun" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pterigiun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pinguecula" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pinguecula" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@seudofaquia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="seudofaquia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@daltonismo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="daltonismo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@normal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="normal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT cod_analisis, ci_empleado, uso_lentes, oi_sin, od_sin, io_con, od_con, miopia, astigmatismo, hipermetropia, pterigiun, pinguecula, seudofaquia, daltonismo, normal, acciones_atomar, observaciones, fecha FROM dbo.AnalisisOftalmologico</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[AnalisisOftalmologico] SET [ci_empleado] = @ci_empleado, [uso_lentes] = @uso_lentes, [oi_sin] = @oi_sin, [od_sin] = @od_sin, [io_con] = @io_con, [od_con] = @od_con, [miopia] = @miopia, [astigmatismo] = @astigmatismo, [hipermetropia] = @hipermetropia, [pterigiun] = @pterigiun, [pinguecula] = @pinguecula, [seudofaquia] = @seudofaquia, [daltonismo] = @daltonismo, [normal] = @normal, [acciones_atomar] = @acciones_atomar, [observaciones] = @observaciones, [fecha] = @fecha WHERE (([cod_analisis] = @Original_cod_analisis) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_uso_lentes = 1 AND [uso_lentes] IS NULL) OR ([uso_lentes] = @Original_uso_lentes)) AND ((@IsNull_oi_sin = 1 AND [oi_sin] IS NULL) OR ([oi_sin] = @Original_oi_sin)) AND ((@IsNull_od_sin = 1 AND [od_sin] IS NULL) OR ([od_sin] = @Original_od_sin)) AND ((@IsNull_io_con = 1 AND [io_con] IS NULL) OR ([io_con] = @Original_io_con)) AND ((@IsNull_od_con = 1 AND [od_con] IS NULL) OR ([od_con] = @Original_od_con)) AND ((@IsNull_miopia = 1 AND [miopia] IS NULL) OR ([miopia] = @Original_miopia)) AND ((@IsNull_astigmatismo = 1 AND [astigmatismo] IS NULL) OR ([astigmatismo] = @Original_astigmatismo)) AND ((@IsNull_hipermetropia = 1 AND [hipermetropia] IS NULL) OR ([hipermetropia] = @Original_hipermetropia)) AND ((@IsNull_pterigiun = 1 AND [pterigiun] IS NULL) OR ([pterigiun] = @Original_pterigiun)) AND ((@IsNull_pinguecula = 1 AND [pinguecula] IS NULL) OR ([pinguecula] = @Original_pinguecula)) AND ((@IsNull_seudofaquia = 1 AND [seudofaquia] IS NULL) OR ([seudofaquia] = @Original_seudofaquia)) AND ((@IsNull_daltonismo = 1 AND [daltonismo] IS NULL) OR ([daltonismo] = @Original_daltonismo)) AND ((@IsNull_normal = 1 AND [normal] IS NULL) OR ([normal] = @Original_normal)) AND ((@IsNull_acciones_atomar = 1 AND [acciones_atomar] IS NULL) OR ([acciones_atomar] = @Original_acciones_atomar)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)));
SELECT cod_analisis, ci_empleado, uso_lentes, oi_sin, od_sin, io_con, od_con, miopia, astigmatismo, hipermetropia, pterigiun, pinguecula, seudofaquia, daltonismo, normal, acciones_atomar, observaciones, fecha FROM AnalisisOftalmologico WHERE (ci_empleado = @ci_empleado) AND (cod_analisis = @cod_analisis)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@uso_lentes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="uso_lentes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@oi_sin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oi_sin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@od_sin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="od_sin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@io_con" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="io_con" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@od_con" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="od_con" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@miopia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="miopia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@astigmatismo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="astigmatismo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hipermetropia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hipermetropia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pterigiun" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pterigiun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pinguecula" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pinguecula" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@seudofaquia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="seudofaquia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@daltonismo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="daltonismo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@normal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="normal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_analisis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_analisis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uso_lentes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uso_lentes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_uso_lentes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="uso_lentes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_oi_sin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="oi_sin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_oi_sin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="oi_sin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_od_sin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="od_sin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_od_sin" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="od_sin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_io_con" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="io_con" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_io_con" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="io_con" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_od_con" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="od_con" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_od_con" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="od_con" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_miopia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="miopia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_miopia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="miopia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_astigmatismo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="astigmatismo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_astigmatismo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="astigmatismo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hipermetropia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hipermetropia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hipermetropia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hipermetropia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pterigiun" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pterigiun" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_pterigiun" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pterigiun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pinguecula" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pinguecula" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_pinguecula" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pinguecula" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_seudofaquia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="seudofaquia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_seudofaquia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="seudofaquia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daltonismo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daltonismo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_daltonismo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="daltonismo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_normal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="normal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_normal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="normal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acciones_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="cod_analisis" ColumnName="cod_analisis" DataSourceName="SaludOcupacional.dbo.AnalisisOftalmologico" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@cod_analisis" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="cod_analisis" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cod_analisis" DataSetColumn="cod_analisis" />
              <Mapping SourceColumn="ci_empleado" DataSetColumn="ci_empleado" />
              <Mapping SourceColumn="uso_lentes" DataSetColumn="uso_lentes" />
              <Mapping SourceColumn="oi_sin" DataSetColumn="oi_sin" />
              <Mapping SourceColumn="od_sin" DataSetColumn="od_sin" />
              <Mapping SourceColumn="io_con" DataSetColumn="io_con" />
              <Mapping SourceColumn="od_con" DataSetColumn="od_con" />
              <Mapping SourceColumn="miopia" DataSetColumn="miopia" />
              <Mapping SourceColumn="astigmatismo" DataSetColumn="astigmatismo" />
              <Mapping SourceColumn="hipermetropia" DataSetColumn="hipermetropia" />
              <Mapping SourceColumn="pterigiun" DataSetColumn="pterigiun" />
              <Mapping SourceColumn="pinguecula" DataSetColumn="pinguecula" />
              <Mapping SourceColumn="seudofaquia" DataSetColumn="seudofaquia" />
              <Mapping SourceColumn="daltonismo" DataSetColumn="daltonismo" />
              <Mapping SourceColumn="normal" DataSetColumn="normal" />
              <Mapping SourceColumn="acciones_atomar" DataSetColumn="acciones_atomar" />
              <Mapping SourceColumn="observaciones" DataSetColumn="observaciones" />
              <Mapping SourceColumn="fecha" DataSetColumn="fecha" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnalisisRespiratorioTableAdapter" GeneratorDataComponentClassName="AnalisisRespiratorioTableAdapter" Name="AnalisisRespiratorio" UserDataComponentName="AnalisisRespiratorioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.AnalisisRespiratorio" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[AnalisisRespiratorio] WHERE (([cod_analisis] = @Original_cod_analisis) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_radiografia_torax = 1 AND [radiografia_torax] IS NULL) OR ([radiografia_torax] = @Original_radiografia_torax)) AND ((@IsNull_grado_obstructiva = 1 AND [grado_obstructiva] IS NULL) OR ([grado_obstructiva] = @Original_grado_obstructiva)) AND ((@IsNull_grado_restrictiva = 1 AND [grado_restrictiva] IS NULL) OR ([grado_restrictiva] = @Original_grado_restrictiva)) AND ((@IsNull_nota_radiografia = 1 AND [nota_radiografia] IS NULL) OR ([nota_radiografia] = @Original_nota_radiografia)) AND ((@IsNull_accion_atomar = 1 AND [accion_atomar] IS NULL) OR ([accion_atomar] = @Original_accion_atomar)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_analisis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_analisis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_radiografia_torax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="radiografia_torax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_radiografia_torax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="radiografia_torax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_grado_obstructiva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="grado_obstructiva" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_grado_obstructiva" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grado_obstructiva" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_grado_restrictiva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="grado_restrictiva" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_grado_restrictiva" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grado_restrictiva" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nota_radiografia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nota_radiografia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nota_radiografia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nota_radiografia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_accion_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="accion_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_accion_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accion_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[AnalisisRespiratorio] ([ci_empleado], [radiografia_torax], [grado_obstructiva], [grado_restrictiva], [nota_radiografia], [accion_atomar], [observaciones], [fecha]) VALUES (@ci_empleado, @radiografia_torax, @grado_obstructiva, @grado_restrictiva, @nota_radiografia, @accion_atomar, @observaciones, @fecha);
SELECT cod_analisis, ci_empleado, radiografia_torax, grado_obstructiva, grado_restrictiva, nota_radiografia, accion_atomar, observaciones, fecha FROM AnalisisRespiratorio WHERE (ci_empleado = @ci_empleado) AND (cod_analisis = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@radiografia_torax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="radiografia_torax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@grado_obstructiva" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grado_obstructiva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@grado_restrictiva" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grado_restrictiva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nota_radiografia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nota_radiografia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@accion_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accion_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT cod_analisis, ci_empleado, radiografia_torax, grado_obstructiva, grado_restrictiva, nota_radiografia, accion_atomar, observaciones, fecha FROM dbo.AnalisisRespiratorio</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[AnalisisRespiratorio] SET [ci_empleado] = @ci_empleado, [radiografia_torax] = @radiografia_torax, [grado_obstructiva] = @grado_obstructiva, [grado_restrictiva] = @grado_restrictiva, [nota_radiografia] = @nota_radiografia, [accion_atomar] = @accion_atomar, [observaciones] = @observaciones, [fecha] = @fecha WHERE (([cod_analisis] = @Original_cod_analisis) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_radiografia_torax = 1 AND [radiografia_torax] IS NULL) OR ([radiografia_torax] = @Original_radiografia_torax)) AND ((@IsNull_grado_obstructiva = 1 AND [grado_obstructiva] IS NULL) OR ([grado_obstructiva] = @Original_grado_obstructiva)) AND ((@IsNull_grado_restrictiva = 1 AND [grado_restrictiva] IS NULL) OR ([grado_restrictiva] = @Original_grado_restrictiva)) AND ((@IsNull_nota_radiografia = 1 AND [nota_radiografia] IS NULL) OR ([nota_radiografia] = @Original_nota_radiografia)) AND ((@IsNull_accion_atomar = 1 AND [accion_atomar] IS NULL) OR ([accion_atomar] = @Original_accion_atomar)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)));
SELECT cod_analisis, ci_empleado, radiografia_torax, grado_obstructiva, grado_restrictiva, nota_radiografia, accion_atomar, observaciones, fecha FROM AnalisisRespiratorio WHERE (ci_empleado = @ci_empleado) AND (cod_analisis = @cod_analisis)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@radiografia_torax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="radiografia_torax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@grado_obstructiva" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grado_obstructiva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@grado_restrictiva" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grado_restrictiva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nota_radiografia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nota_radiografia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@accion_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accion_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_analisis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_analisis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_radiografia_torax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="radiografia_torax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_radiografia_torax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="radiografia_torax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_grado_obstructiva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="grado_obstructiva" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_grado_obstructiva" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grado_obstructiva" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_grado_restrictiva" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="grado_restrictiva" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_grado_restrictiva" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grado_restrictiva" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nota_radiografia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nota_radiografia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nota_radiografia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nota_radiografia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_accion_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="accion_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_accion_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accion_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="cod_analisis" ColumnName="cod_analisis" DataSourceName="SaludOcupacional.dbo.AnalisisRespiratorio" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@cod_analisis" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="cod_analisis" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cod_analisis" DataSetColumn="cod_analisis" />
              <Mapping SourceColumn="ci_empleado" DataSetColumn="ci_empleado" />
              <Mapping SourceColumn="radiografia_torax" DataSetColumn="radiografia_torax" />
              <Mapping SourceColumn="grado_obstructiva" DataSetColumn="grado_obstructiva" />
              <Mapping SourceColumn="grado_restrictiva" DataSetColumn="grado_restrictiva" />
              <Mapping SourceColumn="nota_radiografia" DataSetColumn="nota_radiografia" />
              <Mapping SourceColumn="accion_atomar" DataSetColumn="accion_atomar" />
              <Mapping SourceColumn="observaciones" DataSetColumn="observaciones" />
              <Mapping SourceColumn="fecha" DataSetColumn="fecha" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CarnetSanitarioTableAdapter" GeneratorDataComponentClassName="CarnetSanitarioTableAdapter" Name="CarnetSanitario" UserDataComponentName="CarnetSanitarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.CarnetSanitario" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CarnetSanitario] WHERE (([cod_carnet] = @Original_cod_carnet) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_vdrl = 1 AND [vdrl] IS NULL) OR ([vdrl] = @Original_vdrl)) AND ((@IsNull_ascaris = 1 AND [ascaris] IS NULL) OR ([ascaris] = @Original_ascaris)) AND ((@IsNull_amebas = 1 AND [amebas] IS NULL) OR ([amebas] = @Original_amebas)) AND ((@IsNull_giardias = 1 AND [giardias] IS NULL) OR ([giardias] = @Original_giardias)) AND ((@IsNull_nematodos = 1 AND [nematodos] IS NULL) OR ([nematodos] = @Original_nematodos)) AND ((@IsNull_trematodos = 1 AND [trematodos] IS NULL) OR ([trematodos] = @Original_trematodos)) AND ((@IsNull_trichuris = 1 AND [trichuris] IS NULL) OR ([trichuris] = @Original_trichuris)) AND ((@IsNull_otros_parasitos = 1 AND [otros_parasitos] IS NULL) OR ([otros_parasitos] = @Original_otros_parasitos)) AND ((@IsNull_sin_parasitos = 1 AND [sin_parasitos] IS NULL) OR ([sin_parasitos] = @Original_sin_parasitos)) AND ((@IsNull_acciones_atomar = 1 AND [acciones_atomar] IS NULL) OR ([acciones_atomar] = @Original_acciones_atomar)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_carnet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_carnet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vdrl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vdrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ascaris" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ascaris" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ascaris" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ascaris" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_amebas" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="amebas" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_amebas" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="amebas" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giardias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giardias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_giardias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="giardias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nematodos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nematodos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nematodos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nematodos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_trematodos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trematodos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_trematodos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="trematodos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_trichuris" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trichuris" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_trichuris" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="trichuris" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_otros_parasitos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="otros_parasitos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_otros_parasitos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="otros_parasitos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sin_parasitos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sin_parasitos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_sin_parasitos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sin_parasitos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acciones_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CarnetSanitario] ([ci_empleado], [vdrl], [ascaris], [amebas], [giardias], [nematodos], [trematodos], [trichuris], [otros_parasitos], [sin_parasitos], [acciones_atomar], [observaciones], [fecha]) VALUES (@ci_empleado, @vdrl, @ascaris, @amebas, @giardias, @nematodos, @trematodos, @trichuris, @otros_parasitos, @sin_parasitos, @acciones_atomar, @observaciones, @fecha);
SELECT cod_carnet, ci_empleado, vdrl, ascaris, amebas, giardias, nematodos, trematodos, trichuris, otros_parasitos, sin_parasitos, acciones_atomar, observaciones, fecha FROM CarnetSanitario WHERE (ci_empleado = @ci_empleado) AND (cod_carnet = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vdrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ascaris" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ascaris" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@amebas" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="amebas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@giardias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="giardias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nematodos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nematodos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@trematodos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="trematodos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@trichuris" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="trichuris" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@otros_parasitos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="otros_parasitos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sin_parasitos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sin_parasitos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT cod_carnet, ci_empleado, vdrl, ascaris, amebas, giardias, nematodos, trematodos, trichuris, otros_parasitos, sin_parasitos, acciones_atomar, observaciones, fecha FROM dbo.CarnetSanitario</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CarnetSanitario] SET [ci_empleado] = @ci_empleado, [vdrl] = @vdrl, [ascaris] = @ascaris, [amebas] = @amebas, [giardias] = @giardias, [nematodos] = @nematodos, [trematodos] = @trematodos, [trichuris] = @trichuris, [otros_parasitos] = @otros_parasitos, [sin_parasitos] = @sin_parasitos, [acciones_atomar] = @acciones_atomar, [observaciones] = @observaciones, [fecha] = @fecha WHERE (([cod_carnet] = @Original_cod_carnet) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_vdrl = 1 AND [vdrl] IS NULL) OR ([vdrl] = @Original_vdrl)) AND ((@IsNull_ascaris = 1 AND [ascaris] IS NULL) OR ([ascaris] = @Original_ascaris)) AND ((@IsNull_amebas = 1 AND [amebas] IS NULL) OR ([amebas] = @Original_amebas)) AND ((@IsNull_giardias = 1 AND [giardias] IS NULL) OR ([giardias] = @Original_giardias)) AND ((@IsNull_nematodos = 1 AND [nematodos] IS NULL) OR ([nematodos] = @Original_nematodos)) AND ((@IsNull_trematodos = 1 AND [trematodos] IS NULL) OR ([trematodos] = @Original_trematodos)) AND ((@IsNull_trichuris = 1 AND [trichuris] IS NULL) OR ([trichuris] = @Original_trichuris)) AND ((@IsNull_otros_parasitos = 1 AND [otros_parasitos] IS NULL) OR ([otros_parasitos] = @Original_otros_parasitos)) AND ((@IsNull_sin_parasitos = 1 AND [sin_parasitos] IS NULL) OR ([sin_parasitos] = @Original_sin_parasitos)) AND ((@IsNull_acciones_atomar = 1 AND [acciones_atomar] IS NULL) OR ([acciones_atomar] = @Original_acciones_atomar)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)));
SELECT cod_carnet, ci_empleado, vdrl, ascaris, amebas, giardias, nematodos, trematodos, trichuris, otros_parasitos, sin_parasitos, acciones_atomar, observaciones, fecha FROM CarnetSanitario WHERE (ci_empleado = @ci_empleado) AND (cod_carnet = @cod_carnet)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vdrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ascaris" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ascaris" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@amebas" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="amebas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@giardias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="giardias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nematodos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nematodos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@trematodos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="trematodos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@trichuris" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="trichuris" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@otros_parasitos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="otros_parasitos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sin_parasitos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sin_parasitos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_carnet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_carnet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vdrl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vdrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ascaris" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ascaris" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ascaris" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ascaris" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_amebas" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="amebas" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_amebas" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="amebas" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giardias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giardias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_giardias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="giardias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nematodos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nematodos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nematodos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nematodos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_trematodos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trematodos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_trematodos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="trematodos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_trichuris" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trichuris" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_trichuris" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="trichuris" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_otros_parasitos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="otros_parasitos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_otros_parasitos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="otros_parasitos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sin_parasitos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sin_parasitos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_sin_parasitos" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sin_parasitos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acciones_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="cod_carnet" ColumnName="cod_carnet" DataSourceName="SaludOcupacional.dbo.CarnetSanitario" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@cod_carnet" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="cod_carnet" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cod_carnet" DataSetColumn="cod_carnet" />
              <Mapping SourceColumn="ci_empleado" DataSetColumn="ci_empleado" />
              <Mapping SourceColumn="vdrl" DataSetColumn="vdrl" />
              <Mapping SourceColumn="ascaris" DataSetColumn="ascaris" />
              <Mapping SourceColumn="amebas" DataSetColumn="amebas" />
              <Mapping SourceColumn="giardias" DataSetColumn="giardias" />
              <Mapping SourceColumn="nematodos" DataSetColumn="nematodos" />
              <Mapping SourceColumn="trematodos" DataSetColumn="trematodos" />
              <Mapping SourceColumn="trichuris" DataSetColumn="trichuris" />
              <Mapping SourceColumn="otros_parasitos" DataSetColumn="otros_parasitos" />
              <Mapping SourceColumn="sin_parasitos" DataSetColumn="sin_parasitos" />
              <Mapping SourceColumn="acciones_atomar" DataSetColumn="acciones_atomar" />
              <Mapping SourceColumn="observaciones" DataSetColumn="observaciones" />
              <Mapping SourceColumn="fecha" DataSetColumn="fecha" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ConsultaTableAdapter" GeneratorDataComponentClassName="ConsultaTableAdapter" Name="Consulta" UserDataComponentName="ConsultaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.Consulta" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Consulta] WHERE (([cod_consulta] = @Original_cod_consulta) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)) AND ((@IsNull_area_trabajo = 1 AND [area_trabajo] IS NULL) OR ([area_trabajo] = @Original_area_trabajo)) AND ((@IsNull_codigo_embol = 1 AND [codigo_embol] IS NULL) OR ([codigo_embol] = @Original_codigo_embol)) AND ((@IsNull_patologia = 1 AND [patologia] IS NULL) OR ([patologia] = @Original_patologia)) AND ((@IsNull_gravedad = 1 AND [gravedad] IS NULL) OR ([gravedad] = @Original_gravedad)) AND ((@IsNull_origen = 1 AND [origen] IS NULL) OR ([origen] = @Original_origen)) AND ((@IsNull_accion = 1 AND [accion] IS NULL) OR ([accion] = @Original_accion)) AND ((@IsNull_externo = 1 AND [externo] IS NULL) OR ([externo] = @Original_externo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_consulta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_consulta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_area_trabajo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="area_trabajo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_area_trabajo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="area_trabajo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_codigo_embol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo_embol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_codigo_embol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo_embol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_patologia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="patologia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_patologia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="patologia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gravedad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gravedad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_gravedad" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gravedad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_origen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="origen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_origen" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="origen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_accion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="accion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_accion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_externo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="externo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_externo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="externo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Consulta] ([ci_empleado], [fecha], [area_trabajo], [codigo_embol], [patologia], [gravedad], [origen], [accion], [externo]) VALUES (@ci_empleado, @fecha, @area_trabajo, @codigo_embol, @patologia, @gravedad, @origen, @accion, @externo);
SELECT cod_consulta, ci_empleado, fecha, area_trabajo, codigo_embol, patologia, gravedad, origen, accion, externo FROM Consulta WHERE (ci_empleado = @ci_empleado) AND (cod_consulta = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@area_trabajo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="area_trabajo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@codigo_embol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo_embol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@patologia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="patologia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@gravedad" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gravedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@origen" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="origen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@accion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@externo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="externo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT cod_consulta, ci_empleado, fecha, area_trabajo, codigo_embol, patologia, gravedad, origen, accion, externo FROM dbo.Consulta</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Consulta] SET [ci_empleado] = @ci_empleado, [fecha] = @fecha, [area_trabajo] = @area_trabajo, [codigo_embol] = @codigo_embol, [patologia] = @patologia, [gravedad] = @gravedad, [origen] = @origen, [accion] = @accion, [externo] = @externo WHERE (([cod_consulta] = @Original_cod_consulta) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)) AND ((@IsNull_area_trabajo = 1 AND [area_trabajo] IS NULL) OR ([area_trabajo] = @Original_area_trabajo)) AND ((@IsNull_codigo_embol = 1 AND [codigo_embol] IS NULL) OR ([codigo_embol] = @Original_codigo_embol)) AND ((@IsNull_patologia = 1 AND [patologia] IS NULL) OR ([patologia] = @Original_patologia)) AND ((@IsNull_gravedad = 1 AND [gravedad] IS NULL) OR ([gravedad] = @Original_gravedad)) AND ((@IsNull_origen = 1 AND [origen] IS NULL) OR ([origen] = @Original_origen)) AND ((@IsNull_accion = 1 AND [accion] IS NULL) OR ([accion] = @Original_accion)) AND ((@IsNull_externo = 1 AND [externo] IS NULL) OR ([externo] = @Original_externo)));
SELECT cod_consulta, ci_empleado, fecha, area_trabajo, codigo_embol, patologia, gravedad, origen, accion, externo FROM Consulta WHERE (ci_empleado = @ci_empleado) AND (cod_consulta = @cod_consulta)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@area_trabajo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="area_trabajo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@codigo_embol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo_embol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@patologia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="patologia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@gravedad" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gravedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@origen" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="origen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@accion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@externo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="externo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_consulta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_consulta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_area_trabajo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="area_trabajo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_area_trabajo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="area_trabajo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_codigo_embol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo_embol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_codigo_embol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo_embol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_patologia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="patologia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_patologia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="patologia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gravedad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gravedad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_gravedad" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gravedad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_origen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="origen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_origen" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="origen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_accion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="accion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_accion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="accion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_externo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="externo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_externo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="externo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="cod_consulta" ColumnName="cod_consulta" DataSourceName="SaludOcupacional.dbo.Consulta" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@cod_consulta" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="cod_consulta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cod_consulta" DataSetColumn="cod_consulta" />
              <Mapping SourceColumn="ci_empleado" DataSetColumn="ci_empleado" />
              <Mapping SourceColumn="fecha" DataSetColumn="fecha" />
              <Mapping SourceColumn="area_trabajo" DataSetColumn="area_trabajo" />
              <Mapping SourceColumn="codigo_embol" DataSetColumn="codigo_embol" />
              <Mapping SourceColumn="patologia" DataSetColumn="patologia" />
              <Mapping SourceColumn="gravedad" DataSetColumn="gravedad" />
              <Mapping SourceColumn="origen" DataSetColumn="origen" />
              <Mapping SourceColumn="accion" DataSetColumn="accion" />
              <Mapping SourceColumn="externo" DataSetColumn="externo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CronogramasTableAdapter" GeneratorDataComponentClassName="CronogramasTableAdapter" Name="Cronogramas" UserDataComponentName="CronogramasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.Cronogramas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cronogramas] WHERE (([cod_cronograma] = @Original_cod_cronograma) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)) AND ((@IsNull_analisis = 1 AND [analisis] IS NULL) OR ([analisis] = @Original_analisis)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_cronograma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_cronograma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_analisis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="analisis" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_analisis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="analisis" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cronogramas] ([ci_empleado], [fecha], [analisis]) VALUES (@ci_empleado, @fecha, @analisis);
SELECT cod_cronograma, ci_empleado, fecha, analisis FROM Cronogramas WHERE (ci_empleado = @ci_empleado) AND (cod_cronograma = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@analisis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="analisis" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT cod_cronograma, ci_empleado, fecha, analisis FROM dbo.Cronogramas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cronogramas] SET [ci_empleado] = @ci_empleado, [fecha] = @fecha, [analisis] = @analisis WHERE (([cod_cronograma] = @Original_cod_cronograma) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)) AND ((@IsNull_analisis = 1 AND [analisis] IS NULL) OR ([analisis] = @Original_analisis)));
SELECT cod_cronograma, ci_empleado, fecha, analisis FROM Cronogramas WHERE (ci_empleado = @ci_empleado) AND (cod_cronograma = @cod_cronograma)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@analisis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="analisis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_cronograma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_cronograma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_analisis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="analisis" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_analisis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="analisis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="cod_cronograma" ColumnName="cod_cronograma" DataSourceName="SaludOcupacional.dbo.Cronogramas" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@cod_cronograma" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="cod_cronograma" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cod_cronograma" DataSetColumn="cod_cronograma" />
              <Mapping SourceColumn="ci_empleado" DataSetColumn="ci_empleado" />
              <Mapping SourceColumn="fecha" DataSetColumn="fecha" />
              <Mapping SourceColumn="analisis" DataSetColumn="analisis" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DatosIngresoTableAdapter" GeneratorDataComponentClassName="DatosIngresoTableAdapter" Name="DatosIngreso" UserDataComponentName="DatosIngresoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.DatosIngreso" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DatosIngreso] WHERE (([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_puesto_trabajo = 1 AND [puesto_trabajo] IS NULL) OR ([puesto_trabajo] = @Original_puesto_trabajo)) AND ((@IsNull_fecha_ingreso = 1 AND [fecha_ingreso] IS NULL) OR ([fecha_ingreso] = @Original_fecha_ingreso)) AND ((@IsNull_fecha_traslado = 1 AND [fecha_traslado] IS NULL) OR ([fecha_traslado] = @Original_fecha_traslado)) AND ((@IsNull_fecha_salida = 1 AND [fecha_salida] IS NULL) OR ([fecha_salida] = @Original_fecha_salida)) AND ([cod_datos] = @Original_cod_datos))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_puesto_trabajo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="puesto_trabajo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_puesto_trabajo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="puesto_trabajo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha_ingreso" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha_ingreso" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_ingreso" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_ingreso" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha_traslado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha_traslado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_traslado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_traslado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha_salida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha_salida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_salida" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_salida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_datos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_datos" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DatosIngreso] ([ci_empleado], [puesto_trabajo], [fecha_ingreso], [fecha_traslado], [fecha_salida]) VALUES (@ci_empleado, @puesto_trabajo, @fecha_ingreso, @fecha_traslado, @fecha_salida);
SELECT ci_empleado, puesto_trabajo, fecha_ingreso, fecha_traslado, fecha_salida, cod_datos FROM DatosIngreso WHERE (cod_datos = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@puesto_trabajo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="puesto_trabajo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_ingreso" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_ingreso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_traslado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_traslado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_salida" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_salida" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ci_empleado, puesto_trabajo, fecha_ingreso, fecha_traslado, fecha_salida, cod_datos FROM dbo.DatosIngreso</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DatosIngreso] SET [ci_empleado] = @ci_empleado, [puesto_trabajo] = @puesto_trabajo, [fecha_ingreso] = @fecha_ingreso, [fecha_traslado] = @fecha_traslado, [fecha_salida] = @fecha_salida WHERE (([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_puesto_trabajo = 1 AND [puesto_trabajo] IS NULL) OR ([puesto_trabajo] = @Original_puesto_trabajo)) AND ((@IsNull_fecha_ingreso = 1 AND [fecha_ingreso] IS NULL) OR ([fecha_ingreso] = @Original_fecha_ingreso)) AND ((@IsNull_fecha_traslado = 1 AND [fecha_traslado] IS NULL) OR ([fecha_traslado] = @Original_fecha_traslado)) AND ((@IsNull_fecha_salida = 1 AND [fecha_salida] IS NULL) OR ([fecha_salida] = @Original_fecha_salida)) AND ([cod_datos] = @Original_cod_datos));
SELECT ci_empleado, puesto_trabajo, fecha_ingreso, fecha_traslado, fecha_salida, cod_datos FROM DatosIngreso WHERE (cod_datos = @cod_datos)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@puesto_trabajo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="puesto_trabajo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_ingreso" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_ingreso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_traslado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_traslado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_salida" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_salida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_puesto_trabajo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="puesto_trabajo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_puesto_trabajo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="puesto_trabajo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha_ingreso" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha_ingreso" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_ingreso" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_ingreso" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha_traslado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha_traslado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_traslado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_traslado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha_salida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha_salida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_salida" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_salida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_datos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_datos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="cod_datos" ColumnName="cod_datos" DataSourceName="SaludOcupacional.dbo.DatosIngreso" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@cod_datos" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="cod_datos" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ci_empleado" DataSetColumn="ci_empleado" />
              <Mapping SourceColumn="puesto_trabajo" DataSetColumn="puesto_trabajo" />
              <Mapping SourceColumn="fecha_ingreso" DataSetColumn="fecha_ingreso" />
              <Mapping SourceColumn="fecha_traslado" DataSetColumn="fecha_traslado" />
              <Mapping SourceColumn="fecha_salida" DataSetColumn="fecha_salida" />
              <Mapping SourceColumn="cod_datos" DataSetColumn="cod_datos" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DiagnosticoLaboratorialTableAdapter" GeneratorDataComponentClassName="DiagnosticoLaboratorialTableAdapter" Name="DiagnosticoLaboratorial" UserDataComponentName="DiagnosticoLaboratorialTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.DiagnosticoLaboratorial" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DiagnosticoLaboratorial] WHERE (([cod_diagnostico] = @Original_cod_diagnostico) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_widal = 1 AND [widal] IS NULL) OR ([widal] = @Original_widal)) AND ((@IsNull_chagas = 1 AND [chagas] IS NULL) OR ([chagas] = @Original_chagas)) AND ((@IsNull_diabetes = 1 AND [diabetes] IS NULL) OR ([diabetes] = @Original_diabetes)) AND ((@IsNull_hepatitis = 1 AND [hepatitis] IS NULL) OR ([hepatitis] = @Original_hepatitis)) AND ((@IsNull_vih = 1 AND [vih] IS NULL) OR ([vih] = @Original_vih)) AND ((@IsNull_plomo_sangre = 1 AND [plomo_sangre] IS NULL) OR ([plomo_sangre] = @Original_plomo_sangre)) AND ((@IsNull_xileno = 1 AND [xileno] IS NULL) OR ([xileno] = @Original_xileno)) AND ((@IsNull_tolueno = 1 AND [tolueno] IS NULL) OR ([tolueno] = @Original_tolueno)) AND ((@IsNull_analisis_orina = 1 AND [analisis_orina] IS NULL) OR ([analisis_orina] = @Original_analisis_orina)) AND ((@IsNull_hb = 1 AND [hb] IS NULL) OR ([hb] = @Original_hb)) AND ((@IsNull_hto = 1 AND [hto] IS NULL) OR ([hto] = @Original_hto)) AND ((@IsNull_glicemia = 1 AND [glicemia] IS NULL) OR ([glicemia] = @Original_glicemia)) AND ((@IsNull_colesterol = 1 AND [colesterol] IS NULL) OR ([colesterol] = @Original_colesterol)) AND ((@IsNull_trigliceridos = 1 AND [trigliceridos] IS NULL) OR ([trigliceridos] = @Original_trigliceridos)) AND ((@IsNull_acido_urico = 1 AND [acido_urico] IS NULL) OR ([acido_urico] = @Original_acido_urico)) AND ((@IsNull_vdrl = 1 AND [vdrl] IS NULL) OR ([vdrl] = @Original_vdrl)) AND ((@IsNull_creatina = 1 AND [creatina] IS NULL) OR ([creatina] = @Original_creatina)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_acciones_atomar = 1 AND [acciones_atomar] IS NULL) OR ([acciones_atomar] = @Original_acciones_atomar)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_diagnostico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_diagnostico" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_widal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="widal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_widal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="widal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chagas" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chagas" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_chagas" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="chagas" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diabetes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diabetes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_diabetes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="diabetes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hepatitis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hepatitis" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hepatitis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hepatitis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vih" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vih" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vih" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vih" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_plomo_sangre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="plomo_sangre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_plomo_sangre" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="plomo_sangre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_xileno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="xileno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_xileno" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="xileno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tolueno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tolueno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_tolueno" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="tolueno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_analisis_orina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="analisis_orina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_analisis_orina" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="analisis_orina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_hb" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="hb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_hto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="hto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_glicemia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="glicemia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_glicemia" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="glicemia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_colesterol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="colesterol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_colesterol" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="colesterol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_trigliceridos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trigliceridos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_trigliceridos" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="trigliceridos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acido_urico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acido_urico" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_acido_urico" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="acido_urico" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vdrl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vdrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_creatina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="creatina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_creatina" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="creatina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acciones_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DiagnosticoLaboratorial] ([ci_empleado], [widal], [chagas], [diabetes], [hepatitis], [vih], [plomo_sangre], [xileno], [tolueno], [analisis_orina], [hb], [hto], [glicemia], [colesterol], [trigliceridos], [acido_urico], [vdrl], [creatina], [observaciones], [acciones_atomar], [fecha]) VALUES (@ci_empleado, @widal, @chagas, @diabetes, @hepatitis, @vih, @plomo_sangre, @xileno, @tolueno, @analisis_orina, @hb, @hto, @glicemia, @colesterol, @trigliceridos, @acido_urico, @vdrl, @creatina, @observaciones, @acciones_atomar, @fecha);
SELECT cod_diagnostico, ci_empleado, widal, chagas, diabetes, hepatitis, vih, plomo_sangre, xileno, tolueno, analisis_orina, hb, hto, glicemia, colesterol, trigliceridos, acido_urico, vdrl, creatina, observaciones, acciones_atomar, fecha FROM DiagnosticoLaboratorial WHERE (ci_empleado = @ci_empleado) AND (cod_diagnostico = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@widal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="widal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@chagas" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="chagas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@diabetes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="diabetes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hepatitis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hepatitis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vih" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vih" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@plomo_sangre" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="plomo_sangre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@xileno" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="xileno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@tolueno" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="tolueno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@analisis_orina" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="analisis_orina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@hb" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="hb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@hto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="hto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@glicemia" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="glicemia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@colesterol" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="colesterol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@trigliceridos" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="trigliceridos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@acido_urico" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="acido_urico" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vdrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@creatina" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="creatina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT cod_diagnostico, ci_empleado, widal, chagas, diabetes, hepatitis, vih, plomo_sangre, xileno, tolueno, analisis_orina, hb, hto, glicemia, colesterol, trigliceridos, acido_urico, vdrl, creatina, observaciones, acciones_atomar, fecha FROM dbo.DiagnosticoLaboratorial</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DiagnosticoLaboratorial] SET [ci_empleado] = @ci_empleado, [widal] = @widal, [chagas] = @chagas, [diabetes] = @diabetes, [hepatitis] = @hepatitis, [vih] = @vih, [plomo_sangre] = @plomo_sangre, [xileno] = @xileno, [tolueno] = @tolueno, [analisis_orina] = @analisis_orina, [hb] = @hb, [hto] = @hto, [glicemia] = @glicemia, [colesterol] = @colesterol, [trigliceridos] = @trigliceridos, [acido_urico] = @acido_urico, [vdrl] = @vdrl, [creatina] = @creatina, [observaciones] = @observaciones, [acciones_atomar] = @acciones_atomar, [fecha] = @fecha WHERE (([cod_diagnostico] = @Original_cod_diagnostico) AND ([ci_empleado] = @Original_ci_empleado) AND ((@IsNull_widal = 1 AND [widal] IS NULL) OR ([widal] = @Original_widal)) AND ((@IsNull_chagas = 1 AND [chagas] IS NULL) OR ([chagas] = @Original_chagas)) AND ((@IsNull_diabetes = 1 AND [diabetes] IS NULL) OR ([diabetes] = @Original_diabetes)) AND ((@IsNull_hepatitis = 1 AND [hepatitis] IS NULL) OR ([hepatitis] = @Original_hepatitis)) AND ((@IsNull_vih = 1 AND [vih] IS NULL) OR ([vih] = @Original_vih)) AND ((@IsNull_plomo_sangre = 1 AND [plomo_sangre] IS NULL) OR ([plomo_sangre] = @Original_plomo_sangre)) AND ((@IsNull_xileno = 1 AND [xileno] IS NULL) OR ([xileno] = @Original_xileno)) AND ((@IsNull_tolueno = 1 AND [tolueno] IS NULL) OR ([tolueno] = @Original_tolueno)) AND ((@IsNull_analisis_orina = 1 AND [analisis_orina] IS NULL) OR ([analisis_orina] = @Original_analisis_orina)) AND ((@IsNull_hb = 1 AND [hb] IS NULL) OR ([hb] = @Original_hb)) AND ((@IsNull_hto = 1 AND [hto] IS NULL) OR ([hto] = @Original_hto)) AND ((@IsNull_glicemia = 1 AND [glicemia] IS NULL) OR ([glicemia] = @Original_glicemia)) AND ((@IsNull_colesterol = 1 AND [colesterol] IS NULL) OR ([colesterol] = @Original_colesterol)) AND ((@IsNull_trigliceridos = 1 AND [trigliceridos] IS NULL) OR ([trigliceridos] = @Original_trigliceridos)) AND ((@IsNull_acido_urico = 1 AND [acido_urico] IS NULL) OR ([acido_urico] = @Original_acido_urico)) AND ((@IsNull_vdrl = 1 AND [vdrl] IS NULL) OR ([vdrl] = @Original_vdrl)) AND ((@IsNull_creatina = 1 AND [creatina] IS NULL) OR ([creatina] = @Original_creatina)) AND ((@IsNull_observaciones = 1 AND [observaciones] IS NULL) OR ([observaciones] = @Original_observaciones)) AND ((@IsNull_acciones_atomar = 1 AND [acciones_atomar] IS NULL) OR ([acciones_atomar] = @Original_acciones_atomar)) AND ((@IsNull_fecha = 1 AND [fecha] IS NULL) OR ([fecha] = @Original_fecha)));
SELECT cod_diagnostico, ci_empleado, widal, chagas, diabetes, hepatitis, vih, plomo_sangre, xileno, tolueno, analisis_orina, hb, hto, glicemia, colesterol, trigliceridos, acido_urico, vdrl, creatina, observaciones, acciones_atomar, fecha FROM DiagnosticoLaboratorial WHERE (ci_empleado = @ci_empleado) AND (cod_diagnostico = @cod_diagnostico)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@widal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="widal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@chagas" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="chagas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@diabetes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="diabetes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hepatitis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hepatitis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vih" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vih" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@plomo_sangre" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="plomo_sangre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@xileno" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="xileno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@tolueno" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="tolueno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@analisis_orina" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="analisis_orina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@hb" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="hb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@hto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="hto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@glicemia" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="glicemia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@colesterol" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="colesterol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@trigliceridos" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="trigliceridos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@acido_urico" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="acido_urico" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vdrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@creatina" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="creatina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_diagnostico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_diagnostico" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_widal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="widal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_widal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="widal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chagas" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chagas" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_chagas" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="chagas" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diabetes" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diabetes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_diabetes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="diabetes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hepatitis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hepatitis" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hepatitis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hepatitis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vih" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vih" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vih" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vih" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_plomo_sangre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="plomo_sangre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_plomo_sangre" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="plomo_sangre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_xileno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="xileno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_xileno" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="xileno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tolueno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tolueno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_tolueno" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="tolueno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_analisis_orina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="analisis_orina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_analisis_orina" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="analisis_orina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_hb" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="hb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_hto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="hto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_glicemia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="glicemia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_glicemia" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="glicemia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_colesterol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="colesterol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_colesterol" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="colesterol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_trigliceridos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trigliceridos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_trigliceridos" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="trigliceridos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acido_urico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acido_urico" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_acido_urico" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="acido_urico" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vdrl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vdrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vdrl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_creatina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="creatina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_creatina" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="creatina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_observaciones" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_observaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="observaciones" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acciones_atomar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_acciones_atomar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="acciones_atomar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="cod_diagnostico" ColumnName="cod_diagnostico" DataSourceName="SaludOcupacional.dbo.DiagnosticoLaboratorial" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@cod_diagnostico" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="cod_diagnostico" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cod_diagnostico" DataSetColumn="cod_diagnostico" />
              <Mapping SourceColumn="ci_empleado" DataSetColumn="ci_empleado" />
              <Mapping SourceColumn="widal" DataSetColumn="widal" />
              <Mapping SourceColumn="chagas" DataSetColumn="chagas" />
              <Mapping SourceColumn="diabetes" DataSetColumn="diabetes" />
              <Mapping SourceColumn="hepatitis" DataSetColumn="hepatitis" />
              <Mapping SourceColumn="vih" DataSetColumn="vih" />
              <Mapping SourceColumn="plomo_sangre" DataSetColumn="plomo_sangre" />
              <Mapping SourceColumn="xileno" DataSetColumn="xileno" />
              <Mapping SourceColumn="tolueno" DataSetColumn="tolueno" />
              <Mapping SourceColumn="analisis_orina" DataSetColumn="analisis_orina" />
              <Mapping SourceColumn="hb" DataSetColumn="hb" />
              <Mapping SourceColumn="hto" DataSetColumn="hto" />
              <Mapping SourceColumn="glicemia" DataSetColumn="glicemia" />
              <Mapping SourceColumn="colesterol" DataSetColumn="colesterol" />
              <Mapping SourceColumn="trigliceridos" DataSetColumn="trigliceridos" />
              <Mapping SourceColumn="acido_urico" DataSetColumn="acido_urico" />
              <Mapping SourceColumn="vdrl" DataSetColumn="vdrl" />
              <Mapping SourceColumn="creatina" DataSetColumn="creatina" />
              <Mapping SourceColumn="observaciones" DataSetColumn="observaciones" />
              <Mapping SourceColumn="acciones_atomar" DataSetColumn="acciones_atomar" />
              <Mapping SourceColumn="fecha" DataSetColumn="fecha" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmpleadoTableAdapter" GeneratorDataComponentClassName="EmpleadoTableAdapter" Name="Empleado" UserDataComponentName="EmpleadoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.Empleado" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Empleado] WHERE (([ci] = @Original_ci) AND ([cod_empleado] = @Original_cod_empleado) AND ([codigo] = @Original_codigo) AND ([numero_seguro] = @Original_numero_seguro) AND ([exp] = @Original_exp) AND ([nombre] = @Original_nombre) AND ([apellido_paterno] = @Original_apellido_paterno) AND ((@IsNull_apellido_materno = 1 AND [apellido_materno] IS NULL) OR ([apellido_materno] = @Original_apellido_materno)) AND ([fecha_nacimiento] = @Original_fecha_nacimiento) AND ((@IsNull_telefono = 1 AND [telefono] IS NULL) OR ([telefono] = @Original_telefono)) AND ((@IsNull_celular = 1 AND [celular] IS NULL) OR ([celular] = @Original_celular)) AND ((@IsNull_estado = 1 AND [estado] IS NULL) OR ([estado] = @Original_estado)) AND ((@IsNull_grupo_sangre = 1 AND [grupo_sangre] IS NULL) OR ([grupo_sangre] = @Original_grupo_sangre)) AND ((@IsNull_contitucion = 1 AND [contitucion] IS NULL) OR ([contitucion] = @Original_contitucion)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_codigo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numero_seguro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numero_seguro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_exp" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="exp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_apellido_paterno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido_materno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_apellido_materno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_nacimiento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_grupo_sangre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="grupo_sangre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_grupo_sangre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grupo_sangre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_contitucion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="contitucion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_contitucion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contitucion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Empleado] ([ci], [codigo], [numero_seguro], [exp], [nombre], [apellido_paterno], [apellido_materno], [fecha_nacimiento], [telefono], [celular], [estado], [grupo_sangre], [contitucion]) VALUES (@ci, @codigo, @numero_seguro, @exp, @nombre, @apellido_paterno, @apellido_materno, @fecha_nacimiento, @telefono, @celular, @estado, @grupo_sangre, @contitucion);
SELECT ci, cod_empleado, codigo, numero_seguro, exp, nombre, apellido_paterno, apellido_materno, fecha_nacimiento, telefono, celular, estado, grupo_sangre, contitucion FROM Empleado WHERE (ci = @ci)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@codigo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numero_seguro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numero_seguro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@exp" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="exp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apellido_paterno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apellido_materno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_nacimiento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@grupo_sangre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grupo_sangre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@contitucion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contitucion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ci, cod_empleado, codigo, numero_seguro, exp, nombre, apellido_paterno, apellido_materno, fecha_nacimiento, telefono, celular, estado, grupo_sangre, contitucion FROM dbo.Empleado</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Empleado] SET [ci] = @ci, [codigo] = @codigo, [numero_seguro] = @numero_seguro, [exp] = @exp, [nombre] = @nombre, [apellido_paterno] = @apellido_paterno, [apellido_materno] = @apellido_materno, [fecha_nacimiento] = @fecha_nacimiento, [telefono] = @telefono, [celular] = @celular, [estado] = @estado, [grupo_sangre] = @grupo_sangre, [contitucion] = @contitucion WHERE (([ci] = @Original_ci) AND ([cod_empleado] = @Original_cod_empleado) AND ([codigo] = @Original_codigo) AND ([numero_seguro] = @Original_numero_seguro) AND ([exp] = @Original_exp) AND ([nombre] = @Original_nombre) AND ([apellido_paterno] = @Original_apellido_paterno) AND ((@IsNull_apellido_materno = 1 AND [apellido_materno] IS NULL) OR ([apellido_materno] = @Original_apellido_materno)) AND ([fecha_nacimiento] = @Original_fecha_nacimiento) AND ((@IsNull_telefono = 1 AND [telefono] IS NULL) OR ([telefono] = @Original_telefono)) AND ((@IsNull_celular = 1 AND [celular] IS NULL) OR ([celular] = @Original_celular)) AND ((@IsNull_estado = 1 AND [estado] IS NULL) OR ([estado] = @Original_estado)) AND ((@IsNull_grupo_sangre = 1 AND [grupo_sangre] IS NULL) OR ([grupo_sangre] = @Original_grupo_sangre)) AND ((@IsNull_contitucion = 1 AND [contitucion] IS NULL) OR ([contitucion] = @Original_contitucion)));
SELECT ci, cod_empleado, codigo, numero_seguro, exp, nombre, apellido_paterno, apellido_materno, fecha_nacimiento, telefono, celular, estado, grupo_sangre, contitucion FROM Empleado WHERE (ci = @ci)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ci" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@codigo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numero_seguro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numero_seguro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@exp" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="exp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apellido_paterno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apellido_materno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_nacimiento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@grupo_sangre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grupo_sangre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@contitucion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contitucion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ci" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ci" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_empleado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_empleado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_codigo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numero_seguro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numero_seguro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_exp" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="exp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_apellido_paterno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido_materno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_apellido_materno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_nacimiento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_grupo_sangre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="grupo_sangre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_grupo_sangre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grupo_sangre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_contitucion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="contitucion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_contitucion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contitucion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ci" DataSetColumn="ci" />
              <Mapping SourceColumn="cod_empleado" DataSetColumn="cod_empleado" />
              <Mapping SourceColumn="codigo" DataSetColumn="codigo" />
              <Mapping SourceColumn="numero_seguro" DataSetColumn="numero_seguro" />
              <Mapping SourceColumn="exp" DataSetColumn="exp" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
              <Mapping SourceColumn="apellido_paterno" DataSetColumn="apellido_paterno" />
              <Mapping SourceColumn="apellido_materno" DataSetColumn="apellido_materno" />
              <Mapping SourceColumn="fecha_nacimiento" DataSetColumn="fecha_nacimiento" />
              <Mapping SourceColumn="telefono" DataSetColumn="telefono" />
              <Mapping SourceColumn="celular" DataSetColumn="celular" />
              <Mapping SourceColumn="estado" DataSetColumn="estado" />
              <Mapping SourceColumn="grupo_sangre" DataSetColumn="grupo_sangre" />
              <Mapping SourceColumn="contitucion" DataSetColumn="contitucion" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsuarioTableAdapter" GeneratorDataComponentClassName="UsuarioTableAdapter" Name="Usuario" UserDataComponentName="UsuarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SaludOcupacionalConnectionString (Settings)" DbObjectName="SaludOcupacional.dbo.Usuario" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Usuario] WHERE (([cod_usuario] = @Original_cod_usuario) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_privilegio = 1 AND [privilegio] IS NULL) OR ([privilegio] = @Original_privilegio)) AND ((@IsNull_nombre = 1 AND [nombre] IS NULL) OR ([nombre] = @Original_nombre)) AND ((@IsNull_apellido_materno = 1 AND [apellido_materno] IS NULL) OR ([apellido_materno] = @Original_apellido_materno)) AND ((@IsNull_apellido_paterno = 1 AND [apellido_paterno] IS NULL) OR ([apellido_paterno] = @Original_apellido_paterno)) AND ((@IsNull_telefono = 1 AND [telefono] IS NULL) OR ([telefono] = @Original_telefono)) AND ((@IsNull_direccion = 1 AND [direccion] IS NULL) OR ([direccion] = @Original_direccion)) AND ((@IsNull_fecha_nacimiento = 1 AND [fecha_nacimiento] IS NULL) OR ([fecha_nacimiento] = @Original_fecha_nacimiento)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_celular = 1 AND [celular] IS NULL) OR ([celular] = @Original_celular)) AND ((@IsNull_stado = 1 AND [stado] IS NULL) OR ([stado] = @Original_stado)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_privilegio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="privilegio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="privilegio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido_materno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_apellido_materno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido_paterno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_apellido_paterno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_direccion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha_nacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_nacimiento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_stado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="stado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_stado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="stado" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Usuario] ([login], [password], [privilegio], [nombre], [apellido_materno], [apellido_paterno], [telefono], [direccion], [fecha_nacimiento], [email], [celular], [stado]) VALUES (@login, @password, @privilegio, @nombre, @apellido_materno, @apellido_paterno, @telefono, @direccion, @fecha_nacimiento, @email, @celular, @stado);
SELECT cod_usuario, login, password, privilegio, nombre, apellido_materno, apellido_paterno, telefono, direccion, fecha_nacimiento, email, celular, stado FROM Usuario WHERE (cod_usuario = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="privilegio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apellido_materno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apellido_paterno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@direccion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_nacimiento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@stado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="stado" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT cod_usuario, login, password, privilegio, nombre, apellido_materno, apellido_paterno, telefono, direccion, fecha_nacimiento, email, celular, stado FROM dbo.Usuario</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Usuario] SET [login] = @login, [password] = @password, [privilegio] = @privilegio, [nombre] = @nombre, [apellido_materno] = @apellido_materno, [apellido_paterno] = @apellido_paterno, [telefono] = @telefono, [direccion] = @direccion, [fecha_nacimiento] = @fecha_nacimiento, [email] = @email, [celular] = @celular, [stado] = @stado WHERE (([cod_usuario] = @Original_cod_usuario) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_privilegio = 1 AND [privilegio] IS NULL) OR ([privilegio] = @Original_privilegio)) AND ((@IsNull_nombre = 1 AND [nombre] IS NULL) OR ([nombre] = @Original_nombre)) AND ((@IsNull_apellido_materno = 1 AND [apellido_materno] IS NULL) OR ([apellido_materno] = @Original_apellido_materno)) AND ((@IsNull_apellido_paterno = 1 AND [apellido_paterno] IS NULL) OR ([apellido_paterno] = @Original_apellido_paterno)) AND ((@IsNull_telefono = 1 AND [telefono] IS NULL) OR ([telefono] = @Original_telefono)) AND ((@IsNull_direccion = 1 AND [direccion] IS NULL) OR ([direccion] = @Original_direccion)) AND ((@IsNull_fecha_nacimiento = 1 AND [fecha_nacimiento] IS NULL) OR ([fecha_nacimiento] = @Original_fecha_nacimiento)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_celular = 1 AND [celular] IS NULL) OR ([celular] = @Original_celular)) AND ((@IsNull_stado = 1 AND [stado] IS NULL) OR ([stado] = @Original_stado)));
SELECT cod_usuario, login, password, privilegio, nombre, apellido_materno, apellido_paterno, telefono, direccion, fecha_nacimiento, email, celular, stado FROM Usuario WHERE (cod_usuario = @cod_usuario)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="privilegio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apellido_materno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apellido_paterno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@direccion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fecha_nacimiento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@stado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="stado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cod_usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cod_usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_privilegio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="privilegio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_privilegio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="privilegio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido_materno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_apellido_materno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_materno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_apellido_paterno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_apellido_paterno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apellido_paterno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_direccion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fecha_nacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_fecha_nacimiento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fecha_nacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_celular" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celular" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_stado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="stado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_stado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="stado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="cod_usuario" ColumnName="cod_usuario" DataSourceName="SaludOcupacional.dbo.Usuario" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@cod_usuario" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="cod_usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cod_usuario" DataSetColumn="cod_usuario" />
              <Mapping SourceColumn="login" DataSetColumn="login" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="privilegio" DataSetColumn="privilegio" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
              <Mapping SourceColumn="apellido_materno" DataSetColumn="apellido_materno" />
              <Mapping SourceColumn="apellido_paterno" DataSetColumn="apellido_paterno" />
              <Mapping SourceColumn="telefono" DataSetColumn="telefono" />
              <Mapping SourceColumn="direccion" DataSetColumn="direccion" />
              <Mapping SourceColumn="fecha_nacimiento" DataSetColumn="fecha_nacimiento" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="celular" DataSetColumn="celular" />
              <Mapping SourceColumn="stado" DataSetColumn="stado" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SaludOcupacionalDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="SaludOcupacionalDataSet" msprop:Generator_UserDSName="SaludOcupacionalDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="AnalisisAudiometrico" msprop:Generator_TableClassName="AnalisisAudiometricoDataTable" msprop:Generator_TableVarName="tableAnalisisAudiometrico" msprop:Generator_TablePropName="AnalisisAudiometrico" msprop:Generator_RowDeletingName="AnalisisAudiometricoRowDeleting" msprop:Generator_UserTableName="AnalisisAudiometrico" msprop:Generator_RowChangingName="AnalisisAudiometricoRowChanging" msprop:Generator_RowEvHandlerName="AnalisisAudiometricoRowChangeEventHandler" msprop:Generator_RowDeletedName="AnalisisAudiometricoRowDeleted" msprop:Generator_RowEvArgName="AnalisisAudiometricoRowChangeEvent" msprop:Generator_RowChangedName="AnalisisAudiometricoRowChanged" msprop:Generator_RowClassName="AnalisisAudiometricoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cod_analisis" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_analisis" msprop:Generator_ColumnPropNameInRow="cod_analisis" msprop:Generator_ColumnPropNameInTable="cod_analisisColumn" msprop:Generator_UserColumnName="cod_analisis" type="xs:int" />
              <xs:element name="ci_empleado" msprop:Generator_ColumnVarNameInTable="columnci_empleado" msprop:Generator_ColumnPropNameInRow="ci_empleado" msprop:Generator_ColumnPropNameInTable="ci_empleadoColumn" msprop:Generator_UserColumnName="ci_empleado" type="xs:int" />
              <xs:element name="oido_izq" msprop:Generator_ColumnVarNameInTable="columnoido_izq" msprop:Generator_ColumnPropNameInRow="oido_izq" msprop:Generator_ColumnPropNameInTable="oido_izqColumn" msprop:Generator_UserColumnName="oido_izq" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="oido_der" msprop:Generator_ColumnVarNameInTable="columnoido_der" msprop:Generator_ColumnPropNameInRow="oido_der" msprop:Generator_ColumnPropNameInTable="oido_derColumn" msprop:Generator_UserColumnName="oido_der" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bilateral" msprop:Generator_ColumnVarNameInTable="columnbilateral" msprop:Generator_ColumnPropNameInRow="bilateral" msprop:Generator_ColumnPropNameInTable="bilateralColumn" msprop:Generator_UserColumnName="bilateral" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="acciones_atomar" msprop:Generator_ColumnVarNameInTable="columnacciones_atomar" msprop:Generator_ColumnPropNameInRow="acciones_atomar" msprop:Generator_ColumnPropNameInTable="acciones_atomarColumn" msprop:Generator_UserColumnName="acciones_atomar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="observaciones" msprop:Generator_ColumnVarNameInTable="columnobservaciones" msprop:Generator_ColumnPropNameInRow="observaciones" msprop:Generator_ColumnPropNameInTable="observacionesColumn" msprop:Generator_UserColumnName="observaciones" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha" msprop:Generator_ColumnVarNameInTable="columnfecha" msprop:Generator_ColumnPropNameInRow="fecha" msprop:Generator_ColumnPropNameInTable="fechaColumn" msprop:Generator_UserColumnName="fecha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AnalisisOftalmologico" msprop:Generator_TableClassName="AnalisisOftalmologicoDataTable" msprop:Generator_TableVarName="tableAnalisisOftalmologico" msprop:Generator_TablePropName="AnalisisOftalmologico" msprop:Generator_RowDeletingName="AnalisisOftalmologicoRowDeleting" msprop:Generator_UserTableName="AnalisisOftalmologico" msprop:Generator_RowChangingName="AnalisisOftalmologicoRowChanging" msprop:Generator_RowEvHandlerName="AnalisisOftalmologicoRowChangeEventHandler" msprop:Generator_RowDeletedName="AnalisisOftalmologicoRowDeleted" msprop:Generator_RowEvArgName="AnalisisOftalmologicoRowChangeEvent" msprop:Generator_RowChangedName="AnalisisOftalmologicoRowChanged" msprop:Generator_RowClassName="AnalisisOftalmologicoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cod_analisis" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_analisis" msprop:Generator_ColumnPropNameInRow="cod_analisis" msprop:Generator_ColumnPropNameInTable="cod_analisisColumn" msprop:Generator_UserColumnName="cod_analisis" type="xs:int" />
              <xs:element name="ci_empleado" msprop:Generator_ColumnVarNameInTable="columnci_empleado" msprop:Generator_ColumnPropNameInRow="ci_empleado" msprop:Generator_ColumnPropNameInTable="ci_empleadoColumn" msprop:Generator_UserColumnName="ci_empleado" type="xs:int" />
              <xs:element name="uso_lentes" msprop:Generator_ColumnVarNameInTable="columnuso_lentes" msprop:Generator_ColumnPropNameInRow="uso_lentes" msprop:Generator_ColumnPropNameInTable="uso_lentesColumn" msprop:Generator_UserColumnName="uso_lentes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="oi_sin" msprop:Generator_ColumnVarNameInTable="columnoi_sin" msprop:Generator_ColumnPropNameInRow="oi_sin" msprop:Generator_ColumnPropNameInTable="oi_sinColumn" msprop:Generator_UserColumnName="oi_sin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="od_sin" msprop:Generator_ColumnVarNameInTable="columnod_sin" msprop:Generator_ColumnPropNameInRow="od_sin" msprop:Generator_ColumnPropNameInTable="od_sinColumn" msprop:Generator_UserColumnName="od_sin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="io_con" msprop:Generator_ColumnVarNameInTable="columnio_con" msprop:Generator_ColumnPropNameInRow="io_con" msprop:Generator_ColumnPropNameInTable="io_conColumn" msprop:Generator_UserColumnName="io_con" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="od_con" msprop:Generator_ColumnVarNameInTable="columnod_con" msprop:Generator_ColumnPropNameInRow="od_con" msprop:Generator_ColumnPropNameInTable="od_conColumn" msprop:Generator_UserColumnName="od_con" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="miopia" msprop:Generator_ColumnVarNameInTable="columnmiopia" msprop:Generator_ColumnPropNameInRow="miopia" msprop:Generator_ColumnPropNameInTable="miopiaColumn" msprop:Generator_UserColumnName="miopia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="astigmatismo" msprop:Generator_ColumnVarNameInTable="columnastigmatismo" msprop:Generator_ColumnPropNameInRow="astigmatismo" msprop:Generator_ColumnPropNameInTable="astigmatismoColumn" msprop:Generator_UserColumnName="astigmatismo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hipermetropia" msprop:Generator_ColumnVarNameInTable="columnhipermetropia" msprop:Generator_ColumnPropNameInRow="hipermetropia" msprop:Generator_ColumnPropNameInTable="hipermetropiaColumn" msprop:Generator_UserColumnName="hipermetropia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pterigiun" msprop:Generator_ColumnVarNameInTable="columnpterigiun" msprop:Generator_ColumnPropNameInRow="pterigiun" msprop:Generator_ColumnPropNameInTable="pterigiunColumn" msprop:Generator_UserColumnName="pterigiun" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pinguecula" msprop:Generator_ColumnVarNameInTable="columnpinguecula" msprop:Generator_ColumnPropNameInRow="pinguecula" msprop:Generator_ColumnPropNameInTable="pingueculaColumn" msprop:Generator_UserColumnName="pinguecula" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="seudofaquia" msprop:Generator_ColumnVarNameInTable="columnseudofaquia" msprop:Generator_ColumnPropNameInRow="seudofaquia" msprop:Generator_ColumnPropNameInTable="seudofaquiaColumn" msprop:Generator_UserColumnName="seudofaquia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="daltonismo" msprop:Generator_ColumnVarNameInTable="columndaltonismo" msprop:Generator_ColumnPropNameInRow="daltonismo" msprop:Generator_ColumnPropNameInTable="daltonismoColumn" msprop:Generator_UserColumnName="daltonismo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="normal" msprop:Generator_ColumnVarNameInTable="columnnormal" msprop:Generator_ColumnPropNameInRow="normal" msprop:Generator_ColumnPropNameInTable="normalColumn" msprop:Generator_UserColumnName="normal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="acciones_atomar" msprop:Generator_ColumnVarNameInTable="columnacciones_atomar" msprop:Generator_ColumnPropNameInRow="acciones_atomar" msprop:Generator_ColumnPropNameInTable="acciones_atomarColumn" msprop:Generator_UserColumnName="acciones_atomar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="observaciones" msprop:Generator_ColumnVarNameInTable="columnobservaciones" msprop:Generator_ColumnPropNameInRow="observaciones" msprop:Generator_ColumnPropNameInTable="observacionesColumn" msprop:Generator_UserColumnName="observaciones" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha" msprop:Generator_ColumnVarNameInTable="columnfecha" msprop:Generator_ColumnPropNameInRow="fecha" msprop:Generator_ColumnPropNameInTable="fechaColumn" msprop:Generator_UserColumnName="fecha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AnalisisRespiratorio" msprop:Generator_TableClassName="AnalisisRespiratorioDataTable" msprop:Generator_TableVarName="tableAnalisisRespiratorio" msprop:Generator_TablePropName="AnalisisRespiratorio" msprop:Generator_RowDeletingName="AnalisisRespiratorioRowDeleting" msprop:Generator_UserTableName="AnalisisRespiratorio" msprop:Generator_RowChangingName="AnalisisRespiratorioRowChanging" msprop:Generator_RowEvHandlerName="AnalisisRespiratorioRowChangeEventHandler" msprop:Generator_RowDeletedName="AnalisisRespiratorioRowDeleted" msprop:Generator_RowEvArgName="AnalisisRespiratorioRowChangeEvent" msprop:Generator_RowChangedName="AnalisisRespiratorioRowChanged" msprop:Generator_RowClassName="AnalisisRespiratorioRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cod_analisis" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_analisis" msprop:Generator_ColumnPropNameInRow="cod_analisis" msprop:Generator_ColumnPropNameInTable="cod_analisisColumn" msprop:Generator_UserColumnName="cod_analisis" type="xs:int" />
              <xs:element name="ci_empleado" msprop:Generator_ColumnVarNameInTable="columnci_empleado" msprop:Generator_ColumnPropNameInRow="ci_empleado" msprop:Generator_ColumnPropNameInTable="ci_empleadoColumn" msprop:Generator_UserColumnName="ci_empleado" type="xs:int" />
              <xs:element name="radiografia_torax" msprop:Generator_ColumnVarNameInTable="columnradiografia_torax" msprop:Generator_ColumnPropNameInRow="radiografia_torax" msprop:Generator_ColumnPropNameInTable="radiografia_toraxColumn" msprop:Generator_UserColumnName="radiografia_torax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="grado_obstructiva" msprop:Generator_ColumnVarNameInTable="columngrado_obstructiva" msprop:Generator_ColumnPropNameInRow="grado_obstructiva" msprop:Generator_ColumnPropNameInTable="grado_obstructivaColumn" msprop:Generator_UserColumnName="grado_obstructiva" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="grado_restrictiva" msprop:Generator_ColumnVarNameInTable="columngrado_restrictiva" msprop:Generator_ColumnPropNameInRow="grado_restrictiva" msprop:Generator_ColumnPropNameInTable="grado_restrictivaColumn" msprop:Generator_UserColumnName="grado_restrictiva" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nota_radiografia" msprop:Generator_ColumnVarNameInTable="columnnota_radiografia" msprop:Generator_ColumnPropNameInRow="nota_radiografia" msprop:Generator_ColumnPropNameInTable="nota_radiografiaColumn" msprop:Generator_UserColumnName="nota_radiografia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="accion_atomar" msprop:Generator_ColumnVarNameInTable="columnaccion_atomar" msprop:Generator_ColumnPropNameInRow="accion_atomar" msprop:Generator_ColumnPropNameInTable="accion_atomarColumn" msprop:Generator_UserColumnName="accion_atomar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="observaciones" msprop:Generator_ColumnVarNameInTable="columnobservaciones" msprop:Generator_ColumnPropNameInRow="observaciones" msprop:Generator_ColumnPropNameInTable="observacionesColumn" msprop:Generator_UserColumnName="observaciones" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha" msprop:Generator_ColumnVarNameInTable="columnfecha" msprop:Generator_ColumnPropNameInRow="fecha" msprop:Generator_ColumnPropNameInTable="fechaColumn" msprop:Generator_UserColumnName="fecha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CarnetSanitario" msprop:Generator_TableClassName="CarnetSanitarioDataTable" msprop:Generator_TableVarName="tableCarnetSanitario" msprop:Generator_TablePropName="CarnetSanitario" msprop:Generator_RowDeletingName="CarnetSanitarioRowDeleting" msprop:Generator_UserTableName="CarnetSanitario" msprop:Generator_RowChangingName="CarnetSanitarioRowChanging" msprop:Generator_RowEvHandlerName="CarnetSanitarioRowChangeEventHandler" msprop:Generator_RowDeletedName="CarnetSanitarioRowDeleted" msprop:Generator_RowEvArgName="CarnetSanitarioRowChangeEvent" msprop:Generator_RowChangedName="CarnetSanitarioRowChanged" msprop:Generator_RowClassName="CarnetSanitarioRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cod_carnet" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_carnet" msprop:Generator_ColumnPropNameInRow="cod_carnet" msprop:Generator_ColumnPropNameInTable="cod_carnetColumn" msprop:Generator_UserColumnName="cod_carnet" type="xs:int" />
              <xs:element name="ci_empleado" msprop:Generator_ColumnVarNameInTable="columnci_empleado" msprop:Generator_ColumnPropNameInRow="ci_empleado" msprop:Generator_ColumnPropNameInTable="ci_empleadoColumn" msprop:Generator_UserColumnName="ci_empleado" type="xs:int" />
              <xs:element name="vdrl" msprop:Generator_ColumnVarNameInTable="columnvdrl" msprop:Generator_ColumnPropNameInRow="vdrl" msprop:Generator_ColumnPropNameInTable="vdrlColumn" msprop:Generator_UserColumnName="vdrl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ascaris" msprop:Generator_ColumnVarNameInTable="columnascaris" msprop:Generator_ColumnPropNameInRow="ascaris" msprop:Generator_ColumnPropNameInTable="ascarisColumn" msprop:Generator_UserColumnName="ascaris" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="amebas" msprop:Generator_ColumnVarNameInTable="columnamebas" msprop:Generator_ColumnPropNameInRow="amebas" msprop:Generator_ColumnPropNameInTable="amebasColumn" msprop:Generator_UserColumnName="amebas" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="giardias" msprop:Generator_ColumnVarNameInTable="columngiardias" msprop:Generator_ColumnPropNameInRow="giardias" msprop:Generator_ColumnPropNameInTable="giardiasColumn" msprop:Generator_UserColumnName="giardias" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nematodos" msprop:Generator_ColumnVarNameInTable="columnnematodos" msprop:Generator_ColumnPropNameInRow="nematodos" msprop:Generator_ColumnPropNameInTable="nematodosColumn" msprop:Generator_UserColumnName="nematodos" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="trematodos" msprop:Generator_ColumnVarNameInTable="columntrematodos" msprop:Generator_ColumnPropNameInRow="trematodos" msprop:Generator_ColumnPropNameInTable="trematodosColumn" msprop:Generator_UserColumnName="trematodos" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="trichuris" msprop:Generator_ColumnVarNameInTable="columntrichuris" msprop:Generator_ColumnPropNameInRow="trichuris" msprop:Generator_ColumnPropNameInTable="trichurisColumn" msprop:Generator_UserColumnName="trichuris" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="otros_parasitos" msprop:Generator_ColumnVarNameInTable="columnotros_parasitos" msprop:Generator_ColumnPropNameInRow="otros_parasitos" msprop:Generator_ColumnPropNameInTable="otros_parasitosColumn" msprop:Generator_UserColumnName="otros_parasitos" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sin_parasitos" msprop:Generator_ColumnVarNameInTable="columnsin_parasitos" msprop:Generator_ColumnPropNameInRow="sin_parasitos" msprop:Generator_ColumnPropNameInTable="sin_parasitosColumn" msprop:Generator_UserColumnName="sin_parasitos" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="acciones_atomar" msprop:Generator_ColumnVarNameInTable="columnacciones_atomar" msprop:Generator_ColumnPropNameInRow="acciones_atomar" msprop:Generator_ColumnPropNameInTable="acciones_atomarColumn" msprop:Generator_UserColumnName="acciones_atomar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="observaciones" msprop:Generator_ColumnVarNameInTable="columnobservaciones" msprop:Generator_ColumnPropNameInRow="observaciones" msprop:Generator_ColumnPropNameInTable="observacionesColumn" msprop:Generator_UserColumnName="observaciones" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha" msprop:Generator_ColumnVarNameInTable="columnfecha" msprop:Generator_ColumnPropNameInRow="fecha" msprop:Generator_ColumnPropNameInTable="fechaColumn" msprop:Generator_UserColumnName="fecha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Consulta" msprop:Generator_TableClassName="ConsultaDataTable" msprop:Generator_TableVarName="tableConsulta" msprop:Generator_TablePropName="Consulta" msprop:Generator_RowDeletingName="ConsultaRowDeleting" msprop:Generator_UserTableName="Consulta" msprop:Generator_RowChangingName="ConsultaRowChanging" msprop:Generator_RowEvHandlerName="ConsultaRowChangeEventHandler" msprop:Generator_RowDeletedName="ConsultaRowDeleted" msprop:Generator_RowEvArgName="ConsultaRowChangeEvent" msprop:Generator_RowChangedName="ConsultaRowChanged" msprop:Generator_RowClassName="ConsultaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cod_consulta" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_consulta" msprop:Generator_ColumnPropNameInRow="cod_consulta" msprop:Generator_ColumnPropNameInTable="cod_consultaColumn" msprop:Generator_UserColumnName="cod_consulta" type="xs:int" />
              <xs:element name="ci_empleado" msprop:Generator_ColumnVarNameInTable="columnci_empleado" msprop:Generator_ColumnPropNameInRow="ci_empleado" msprop:Generator_ColumnPropNameInTable="ci_empleadoColumn" msprop:Generator_UserColumnName="ci_empleado" type="xs:int" />
              <xs:element name="fecha" msprop:Generator_ColumnVarNameInTable="columnfecha" msprop:Generator_ColumnPropNameInRow="fecha" msprop:Generator_ColumnPropNameInTable="fechaColumn" msprop:Generator_UserColumnName="fecha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="area_trabajo" msprop:Generator_ColumnVarNameInTable="columnarea_trabajo" msprop:Generator_ColumnPropNameInRow="area_trabajo" msprop:Generator_ColumnPropNameInTable="area_trabajoColumn" msprop:Generator_UserColumnName="area_trabajo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="codigo_embol" msprop:Generator_ColumnVarNameInTable="columncodigo_embol" msprop:Generator_ColumnPropNameInRow="codigo_embol" msprop:Generator_ColumnPropNameInTable="codigo_embolColumn" msprop:Generator_UserColumnName="codigo_embol" type="xs:int" minOccurs="0" />
              <xs:element name="patologia" msprop:Generator_ColumnVarNameInTable="columnpatologia" msprop:Generator_ColumnPropNameInRow="patologia" msprop:Generator_ColumnPropNameInTable="patologiaColumn" msprop:Generator_UserColumnName="patologia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gravedad" msprop:Generator_ColumnVarNameInTable="columngravedad" msprop:Generator_ColumnPropNameInRow="gravedad" msprop:Generator_ColumnPropNameInTable="gravedadColumn" msprop:Generator_UserColumnName="gravedad" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="origen" msprop:Generator_ColumnVarNameInTable="columnorigen" msprop:Generator_ColumnPropNameInRow="origen" msprop:Generator_ColumnPropNameInTable="origenColumn" msprop:Generator_UserColumnName="origen" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="accion" msprop:Generator_ColumnVarNameInTable="columnaccion" msprop:Generator_ColumnPropNameInRow="accion" msprop:Generator_ColumnPropNameInTable="accionColumn" msprop:Generator_UserColumnName="accion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="externo" msprop:Generator_ColumnVarNameInTable="columnexterno" msprop:Generator_ColumnPropNameInRow="externo" msprop:Generator_ColumnPropNameInTable="externoColumn" msprop:Generator_UserColumnName="externo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Cronogramas" msprop:Generator_TableClassName="CronogramasDataTable" msprop:Generator_TableVarName="tableCronogramas" msprop:Generator_TablePropName="Cronogramas" msprop:Generator_RowDeletingName="CronogramasRowDeleting" msprop:Generator_UserTableName="Cronogramas" msprop:Generator_RowChangingName="CronogramasRowChanging" msprop:Generator_RowEvHandlerName="CronogramasRowChangeEventHandler" msprop:Generator_RowDeletedName="CronogramasRowDeleted" msprop:Generator_RowEvArgName="CronogramasRowChangeEvent" msprop:Generator_RowChangedName="CronogramasRowChanged" msprop:Generator_RowClassName="CronogramasRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cod_cronograma" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_cronograma" msprop:Generator_ColumnPropNameInRow="cod_cronograma" msprop:Generator_ColumnPropNameInTable="cod_cronogramaColumn" msprop:Generator_UserColumnName="cod_cronograma" type="xs:int" />
              <xs:element name="ci_empleado" msprop:Generator_ColumnVarNameInTable="columnci_empleado" msprop:Generator_ColumnPropNameInRow="ci_empleado" msprop:Generator_ColumnPropNameInTable="ci_empleadoColumn" msprop:Generator_UserColumnName="ci_empleado" type="xs:int" />
              <xs:element name="fecha" msprop:Generator_ColumnVarNameInTable="columnfecha" msprop:Generator_ColumnPropNameInRow="fecha" msprop:Generator_ColumnPropNameInTable="fechaColumn" msprop:Generator_UserColumnName="fecha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="analisis" msprop:Generator_ColumnVarNameInTable="columnanalisis" msprop:Generator_ColumnPropNameInRow="analisis" msprop:Generator_ColumnPropNameInTable="analisisColumn" msprop:Generator_UserColumnName="analisis" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DatosIngreso" msprop:Generator_TableClassName="DatosIngresoDataTable" msprop:Generator_TableVarName="tableDatosIngreso" msprop:Generator_TablePropName="DatosIngreso" msprop:Generator_RowDeletingName="DatosIngresoRowDeleting" msprop:Generator_UserTableName="DatosIngreso" msprop:Generator_RowChangingName="DatosIngresoRowChanging" msprop:Generator_RowEvHandlerName="DatosIngresoRowChangeEventHandler" msprop:Generator_RowDeletedName="DatosIngresoRowDeleted" msprop:Generator_RowEvArgName="DatosIngresoRowChangeEvent" msprop:Generator_RowChangedName="DatosIngresoRowChanged" msprop:Generator_RowClassName="DatosIngresoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ci_empleado" msprop:Generator_ColumnVarNameInTable="columnci_empleado" msprop:Generator_ColumnPropNameInRow="ci_empleado" msprop:Generator_ColumnPropNameInTable="ci_empleadoColumn" msprop:Generator_UserColumnName="ci_empleado" type="xs:int" />
              <xs:element name="puesto_trabajo" msprop:Generator_ColumnVarNameInTable="columnpuesto_trabajo" msprop:Generator_ColumnPropNameInRow="puesto_trabajo" msprop:Generator_ColumnPropNameInTable="puesto_trabajoColumn" msprop:Generator_UserColumnName="puesto_trabajo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha_ingreso" msprop:Generator_ColumnVarNameInTable="columnfecha_ingreso" msprop:Generator_ColumnPropNameInRow="fecha_ingreso" msprop:Generator_ColumnPropNameInTable="fecha_ingresoColumn" msprop:Generator_UserColumnName="fecha_ingreso" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha_traslado" msprop:Generator_ColumnVarNameInTable="columnfecha_traslado" msprop:Generator_ColumnPropNameInRow="fecha_traslado" msprop:Generator_ColumnPropNameInTable="fecha_trasladoColumn" msprop:Generator_UserColumnName="fecha_traslado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha_salida" msprop:Generator_ColumnVarNameInTable="columnfecha_salida" msprop:Generator_ColumnPropNameInRow="fecha_salida" msprop:Generator_ColumnPropNameInTable="fecha_salidaColumn" msprop:Generator_UserColumnName="fecha_salida" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cod_datos" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_datos" msprop:Generator_ColumnPropNameInRow="cod_datos" msprop:Generator_ColumnPropNameInTable="cod_datosColumn" msprop:Generator_UserColumnName="cod_datos" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DiagnosticoLaboratorial" msprop:Generator_TableClassName="DiagnosticoLaboratorialDataTable" msprop:Generator_TableVarName="tableDiagnosticoLaboratorial" msprop:Generator_TablePropName="DiagnosticoLaboratorial" msprop:Generator_RowDeletingName="DiagnosticoLaboratorialRowDeleting" msprop:Generator_UserTableName="DiagnosticoLaboratorial" msprop:Generator_RowChangingName="DiagnosticoLaboratorialRowChanging" msprop:Generator_RowEvHandlerName="DiagnosticoLaboratorialRowChangeEventHandler" msprop:Generator_RowDeletedName="DiagnosticoLaboratorialRowDeleted" msprop:Generator_RowEvArgName="DiagnosticoLaboratorialRowChangeEvent" msprop:Generator_RowChangedName="DiagnosticoLaboratorialRowChanged" msprop:Generator_RowClassName="DiagnosticoLaboratorialRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cod_diagnostico" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_diagnostico" msprop:Generator_ColumnPropNameInRow="cod_diagnostico" msprop:Generator_ColumnPropNameInTable="cod_diagnosticoColumn" msprop:Generator_UserColumnName="cod_diagnostico" type="xs:int" />
              <xs:element name="ci_empleado" msprop:Generator_ColumnVarNameInTable="columnci_empleado" msprop:Generator_ColumnPropNameInRow="ci_empleado" msprop:Generator_ColumnPropNameInTable="ci_empleadoColumn" msprop:Generator_UserColumnName="ci_empleado" type="xs:int" />
              <xs:element name="widal" msprop:Generator_ColumnVarNameInTable="columnwidal" msprop:Generator_ColumnPropNameInRow="widal" msprop:Generator_ColumnPropNameInTable="widalColumn" msprop:Generator_UserColumnName="widal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chagas" msprop:Generator_ColumnVarNameInTable="columnchagas" msprop:Generator_ColumnPropNameInRow="chagas" msprop:Generator_ColumnPropNameInTable="chagasColumn" msprop:Generator_UserColumnName="chagas" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diabetes" msprop:Generator_ColumnVarNameInTable="columndiabetes" msprop:Generator_ColumnPropNameInRow="diabetes" msprop:Generator_ColumnPropNameInTable="diabetesColumn" msprop:Generator_UserColumnName="diabetes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hepatitis" msprop:Generator_ColumnVarNameInTable="columnhepatitis" msprop:Generator_ColumnPropNameInRow="hepatitis" msprop:Generator_ColumnPropNameInTable="hepatitisColumn" msprop:Generator_UserColumnName="hepatitis" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vih" msprop:Generator_ColumnVarNameInTable="columnvih" msprop:Generator_ColumnPropNameInRow="vih" msprop:Generator_ColumnPropNameInTable="vihColumn" msprop:Generator_UserColumnName="vih" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="plomo_sangre" msprop:Generator_ColumnVarNameInTable="columnplomo_sangre" msprop:Generator_ColumnPropNameInRow="plomo_sangre" msprop:Generator_ColumnPropNameInTable="plomo_sangreColumn" msprop:Generator_UserColumnName="plomo_sangre" type="xs:double" minOccurs="0" />
              <xs:element name="xileno" msprop:Generator_ColumnVarNameInTable="columnxileno" msprop:Generator_ColumnPropNameInRow="xileno" msprop:Generator_ColumnPropNameInTable="xilenoColumn" msprop:Generator_UserColumnName="xileno" type="xs:double" minOccurs="0" />
              <xs:element name="tolueno" msprop:Generator_ColumnVarNameInTable="columntolueno" msprop:Generator_ColumnPropNameInRow="tolueno" msprop:Generator_ColumnPropNameInTable="toluenoColumn" msprop:Generator_UserColumnName="tolueno" type="xs:double" minOccurs="0" />
              <xs:element name="analisis_orina" msprop:Generator_ColumnVarNameInTable="columnanalisis_orina" msprop:Generator_ColumnPropNameInRow="analisis_orina" msprop:Generator_ColumnPropNameInTable="analisis_orinaColumn" msprop:Generator_UserColumnName="analisis_orina" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hb" msprop:Generator_ColumnVarNameInTable="columnhb" msprop:Generator_ColumnPropNameInRow="hb" msprop:Generator_ColumnPropNameInTable="hbColumn" msprop:Generator_UserColumnName="hb" type="xs:double" minOccurs="0" />
              <xs:element name="hto" msprop:Generator_ColumnVarNameInTable="columnhto" msprop:Generator_ColumnPropNameInRow="hto" msprop:Generator_ColumnPropNameInTable="htoColumn" msprop:Generator_UserColumnName="hto" type="xs:double" minOccurs="0" />
              <xs:element name="glicemia" msprop:Generator_ColumnVarNameInTable="columnglicemia" msprop:Generator_ColumnPropNameInRow="glicemia" msprop:Generator_ColumnPropNameInTable="glicemiaColumn" msprop:Generator_UserColumnName="glicemia" type="xs:double" minOccurs="0" />
              <xs:element name="colesterol" msprop:Generator_ColumnVarNameInTable="columncolesterol" msprop:Generator_ColumnPropNameInRow="colesterol" msprop:Generator_ColumnPropNameInTable="colesterolColumn" msprop:Generator_UserColumnName="colesterol" type="xs:double" minOccurs="0" />
              <xs:element name="trigliceridos" msprop:Generator_ColumnVarNameInTable="columntrigliceridos" msprop:Generator_ColumnPropNameInRow="trigliceridos" msprop:Generator_ColumnPropNameInTable="trigliceridosColumn" msprop:Generator_UserColumnName="trigliceridos" type="xs:double" minOccurs="0" />
              <xs:element name="acido_urico" msprop:Generator_ColumnVarNameInTable="columnacido_urico" msprop:Generator_ColumnPropNameInRow="acido_urico" msprop:Generator_ColumnPropNameInTable="acido_uricoColumn" msprop:Generator_UserColumnName="acido_urico" type="xs:double" minOccurs="0" />
              <xs:element name="vdrl" msprop:Generator_ColumnVarNameInTable="columnvdrl" msprop:Generator_ColumnPropNameInRow="vdrl" msprop:Generator_ColumnPropNameInTable="vdrlColumn" msprop:Generator_UserColumnName="vdrl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="creatina" msprop:Generator_ColumnVarNameInTable="columncreatina" msprop:Generator_ColumnPropNameInRow="creatina" msprop:Generator_ColumnPropNameInTable="creatinaColumn" msprop:Generator_UserColumnName="creatina" type="xs:double" minOccurs="0" />
              <xs:element name="observaciones" msprop:Generator_ColumnVarNameInTable="columnobservaciones" msprop:Generator_ColumnPropNameInRow="observaciones" msprop:Generator_ColumnPropNameInTable="observacionesColumn" msprop:Generator_UserColumnName="observaciones" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="acciones_atomar" msprop:Generator_ColumnVarNameInTable="columnacciones_atomar" msprop:Generator_ColumnPropNameInRow="acciones_atomar" msprop:Generator_ColumnPropNameInTable="acciones_atomarColumn" msprop:Generator_UserColumnName="acciones_atomar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha" msprop:Generator_ColumnVarNameInTable="columnfecha" msprop:Generator_ColumnPropNameInRow="fecha" msprop:Generator_ColumnPropNameInTable="fechaColumn" msprop:Generator_UserColumnName="fecha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Empleado" msprop:Generator_TableClassName="EmpleadoDataTable" msprop:Generator_TableVarName="tableEmpleado" msprop:Generator_TablePropName="Empleado" msprop:Generator_RowDeletingName="EmpleadoRowDeleting" msprop:Generator_UserTableName="Empleado" msprop:Generator_RowChangingName="EmpleadoRowChanging" msprop:Generator_RowEvHandlerName="EmpleadoRowChangeEventHandler" msprop:Generator_RowDeletedName="EmpleadoRowDeleted" msprop:Generator_RowEvArgName="EmpleadoRowChangeEvent" msprop:Generator_RowChangedName="EmpleadoRowChanged" msprop:Generator_RowClassName="EmpleadoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ci" msprop:Generator_ColumnVarNameInTable="columnci" msprop:Generator_ColumnPropNameInRow="ci" msprop:Generator_ColumnPropNameInTable="ciColumn" msprop:Generator_UserColumnName="ci" type="xs:int" />
              <xs:element name="cod_empleado" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_empleado" msprop:Generator_ColumnPropNameInRow="cod_empleado" msprop:Generator_ColumnPropNameInTable="cod_empleadoColumn" msprop:Generator_UserColumnName="cod_empleado" type="xs:int" />
              <xs:element name="codigo" msprop:Generator_ColumnVarNameInTable="columncodigo" msprop:Generator_ColumnPropNameInRow="codigo" msprop:Generator_ColumnPropNameInTable="codigoColumn" msprop:Generator_UserColumnName="codigo" type="xs:int" />
              <xs:element name="numero_seguro" msprop:Generator_ColumnVarNameInTable="columnnumero_seguro" msprop:Generator_ColumnPropNameInRow="numero_seguro" msprop:Generator_ColumnPropNameInTable="numero_seguroColumn" msprop:Generator_UserColumnName="numero_seguro" type="xs:int" />
              <xs:element name="exp" msprop:Generator_ColumnVarNameInTable="columnexp" msprop:Generator_ColumnPropNameInRow="exp" msprop:Generator_ColumnPropNameInTable="expColumn" msprop:Generator_UserColumnName="exp">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nombre" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" msprop:Generator_UserColumnName="nombre">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="apellido_paterno" msprop:Generator_ColumnVarNameInTable="columnapellido_paterno" msprop:Generator_ColumnPropNameInRow="apellido_paterno" msprop:Generator_ColumnPropNameInTable="apellido_paternoColumn" msprop:Generator_UserColumnName="apellido_paterno">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="apellido_materno" msprop:Generator_ColumnVarNameInTable="columnapellido_materno" msprop:Generator_ColumnPropNameInRow="apellido_materno" msprop:Generator_ColumnPropNameInTable="apellido_maternoColumn" msprop:Generator_UserColumnName="apellido_materno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha_nacimiento" msprop:Generator_ColumnVarNameInTable="columnfecha_nacimiento" msprop:Generator_ColumnPropNameInRow="fecha_nacimiento" msprop:Generator_ColumnPropNameInTable="fecha_nacimientoColumn" msprop:Generator_UserColumnName="fecha_nacimiento">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telefono" msprop:Generator_ColumnVarNameInTable="columntelefono" msprop:Generator_ColumnPropNameInRow="telefono" msprop:Generator_ColumnPropNameInTable="telefonoColumn" msprop:Generator_UserColumnName="telefono" type="xs:int" minOccurs="0" />
              <xs:element name="celular" msprop:Generator_ColumnVarNameInTable="columncelular" msprop:Generator_ColumnPropNameInRow="celular" msprop:Generator_ColumnPropNameInTable="celularColumn" msprop:Generator_UserColumnName="celular" type="xs:int" minOccurs="0" />
              <xs:element name="estado" msprop:Generator_ColumnVarNameInTable="columnestado" msprop:Generator_ColumnPropNameInRow="estado" msprop:Generator_ColumnPropNameInTable="estadoColumn" msprop:Generator_UserColumnName="estado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="grupo_sangre" msprop:Generator_ColumnVarNameInTable="columngrupo_sangre" msprop:Generator_ColumnPropNameInRow="grupo_sangre" msprop:Generator_ColumnPropNameInTable="grupo_sangreColumn" msprop:Generator_UserColumnName="grupo_sangre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contitucion" msprop:Generator_ColumnVarNameInTable="columncontitucion" msprop:Generator_ColumnPropNameInRow="contitucion" msprop:Generator_ColumnPropNameInTable="contitucionColumn" msprop:Generator_UserColumnName="contitucion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Usuario" msprop:Generator_TableClassName="UsuarioDataTable" msprop:Generator_TableVarName="tableUsuario" msprop:Generator_TablePropName="Usuario" msprop:Generator_RowDeletingName="UsuarioRowDeleting" msprop:Generator_UserTableName="Usuario" msprop:Generator_RowChangingName="UsuarioRowChanging" msprop:Generator_RowEvHandlerName="UsuarioRowChangeEventHandler" msprop:Generator_RowDeletedName="UsuarioRowDeleted" msprop:Generator_RowEvArgName="UsuarioRowChangeEvent" msprop:Generator_RowChangedName="UsuarioRowChanged" msprop:Generator_RowClassName="UsuarioRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cod_usuario" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncod_usuario" msprop:Generator_ColumnPropNameInRow="cod_usuario" msprop:Generator_ColumnPropNameInTable="cod_usuarioColumn" msprop:Generator_UserColumnName="cod_usuario" type="xs:int" />
              <xs:element name="login" msprop:Generator_ColumnVarNameInTable="columnlogin" msprop:Generator_ColumnPropNameInRow="login" msprop:Generator_ColumnPropNameInTable="loginColumn" msprop:Generator_UserColumnName="login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="privilegio" msprop:Generator_ColumnVarNameInTable="columnprivilegio" msprop:Generator_ColumnPropNameInRow="privilegio" msprop:Generator_ColumnPropNameInTable="privilegioColumn" msprop:Generator_UserColumnName="privilegio" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nombre" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" msprop:Generator_UserColumnName="nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="apellido_materno" msprop:Generator_ColumnVarNameInTable="columnapellido_materno" msprop:Generator_ColumnPropNameInRow="apellido_materno" msprop:Generator_ColumnPropNameInTable="apellido_maternoColumn" msprop:Generator_UserColumnName="apellido_materno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="apellido_paterno" msprop:Generator_ColumnVarNameInTable="columnapellido_paterno" msprop:Generator_ColumnPropNameInRow="apellido_paterno" msprop:Generator_ColumnPropNameInTable="apellido_paternoColumn" msprop:Generator_UserColumnName="apellido_paterno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telefono" msprop:Generator_ColumnVarNameInTable="columntelefono" msprop:Generator_ColumnPropNameInRow="telefono" msprop:Generator_ColumnPropNameInTable="telefonoColumn" msprop:Generator_UserColumnName="telefono" type="xs:int" minOccurs="0" />
              <xs:element name="direccion" msprop:Generator_ColumnVarNameInTable="columndireccion" msprop:Generator_ColumnPropNameInRow="direccion" msprop:Generator_ColumnPropNameInTable="direccionColumn" msprop:Generator_UserColumnName="direccion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fecha_nacimiento" msprop:Generator_ColumnVarNameInTable="columnfecha_nacimiento" msprop:Generator_ColumnPropNameInRow="fecha_nacimiento" msprop:Generator_ColumnPropNameInTable="fecha_nacimientoColumn" msprop:Generator_UserColumnName="fecha_nacimiento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="celular" msprop:Generator_ColumnVarNameInTable="columncelular" msprop:Generator_ColumnPropNameInRow="celular" msprop:Generator_ColumnPropNameInTable="celularColumn" msprop:Generator_UserColumnName="celular" type="xs:int" minOccurs="0" />
              <xs:element name="stado" msprop:Generator_ColumnVarNameInTable="columnstado" msprop:Generator_ColumnPropNameInRow="stado" msprop:Generator_ColumnPropNameInTable="stadoColumn" msprop:Generator_UserColumnName="stado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AnalisisAudiometrico" />
      <xs:field xpath="mstns:cod_analisis" />
      <xs:field xpath="mstns:ci_empleado" />
    </xs:unique>
    <xs:unique name="AnalisisOftalmologico_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AnalisisOftalmologico" />
      <xs:field xpath="mstns:cod_analisis" />
      <xs:field xpath="mstns:ci_empleado" />
    </xs:unique>
    <xs:unique name="AnalisisRespiratorio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AnalisisRespiratorio" />
      <xs:field xpath="mstns:cod_analisis" />
      <xs:field xpath="mstns:ci_empleado" />
    </xs:unique>
    <xs:unique name="CarnetSanitario_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CarnetSanitario" />
      <xs:field xpath="mstns:cod_carnet" />
      <xs:field xpath="mstns:ci_empleado" />
    </xs:unique>
    <xs:unique name="Consulta_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Consulta" />
      <xs:field xpath="mstns:cod_consulta" />
      <xs:field xpath="mstns:ci_empleado" />
    </xs:unique>
    <xs:unique name="Cronogramas_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cronogramas" />
      <xs:field xpath="mstns:cod_cronograma" />
      <xs:field xpath="mstns:ci_empleado" />
    </xs:unique>
    <xs:unique name="DatosIngreso_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DatosIngreso" />
      <xs:field xpath="mstns:cod_datos" />
    </xs:unique>
    <xs:unique name="DiagnosticoLaboratorial_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DiagnosticoLaboratorial" />
      <xs:field xpath="mstns:cod_diagnostico" />
      <xs:field xpath="mstns:ci_empleado" />
    </xs:unique>
    <xs:unique name="Empleado_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Empleado" />
      <xs:field xpath="mstns:ci" />
    </xs:unique>
    <xs:unique name="Usuario_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Usuario" />
      <xs:field xpath="mstns:cod_usuario" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Consulta_Empleado" msdata:parent="Empleado" msdata:child="Consulta" msdata:parentkey="ci" msdata:childkey="ci_empleado" msprop:Generator_UserChildTable="Consulta" msprop:Generator_ChildPropName="GetConsultaRows" msprop:Generator_UserParentTable="Empleado" msprop:Generator_UserRelationName="FK_Consulta_Empleado" msprop:Generator_RelationVarName="relationFK_Consulta_Empleado" msprop:Generator_ParentPropName="EmpleadoRow" />
      <msdata:Relationship name="FK_DatosIngreso_Empleado" msdata:parent="Empleado" msdata:child="DatosIngreso" msdata:parentkey="ci" msdata:childkey="ci_empleado" msprop:Generator_UserChildTable="DatosIngreso" msprop:Generator_ChildPropName="GetDatosIngresoRows" msprop:Generator_UserParentTable="Empleado" msprop:Generator_UserRelationName="FK_DatosIngreso_Empleado" msprop:Generator_RelationVarName="relationFK_DatosIngreso_Empleado" msprop:Generator_ParentPropName="EmpleadoRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>